excel vb excel macro

How to close/exit VBA Form if conditions are success; (unprotect all sheets with a password) - I created a form for Inputting passwords to unprotect all sheets - Then click the Submit button to execute the code If the password is correct the form did close, how do I close the form if the...

Hello. I am trying to do the following in VB. Reference a cell to a IF & Vlookup statement. Here is what I have currently. Z is a variable that works...data can range from line 6 to line 1000. ---------------------------- Private Sub Reset_Pricing_Click() (works) For Z = 6 To 1000 (works)...

Is there a vba code which can adjust the cell whenever we put a line break alt+enter and adjust the cell such that the data before line break is only to be seen

I have an excel master sheet (output) with columns "A" to "AL", The column "A" will have ID's,column "k" has date , column "AB" have sequence(0,1,2,3,4..) and column "AL" have row count(2,3,4,5,6..). The column A will have same values sometimes i.e,(Duplicate values). I need to copy the entire...

Hello, I have a list of 5000 patients in column A. I have a form that i want the user to be able to enter patients name found in column A then in textbox 2 and 3 populate column B and C of that patient and also be able to add information on that current patient that he searched for Columns...

I am new to VBA programming I know how to copy data from a range and paste it on another range. But I can’t figure out how to copy real time data (the data changes everyday) in a workbook located on a p-drive to another workbook that I created. Some of the cells on the real time data are blank...

I am looking for some VB code for the following. I need to copy all of the data (values only) from worksheet 'extworksheet' in workbook 'extworkbook.xlsx' to worksheet 'localworksheet' in this (active) workbook. Literally replicate the 'extworksheet' into worksheet 'localworksheet' from cell...

Hi, I am looking for excel VBA script where I can attach an image to an outlook mail and add text and picture on the image. Could any one help me out in this. Advance Thanks, Pranathi.

Can some one help me fix this error. When i run it the first time it works fine but when i make the edits and run it agian i get the "Overflow 6 Error" Dim cid(100) As String Dim rX As Range Dim rEnd As Range Dim i As Integer Dim x As Integer x = 0 Set rX =...

Hi, This is my first post on this site, I hope someone can help. Forgive me in advance, as I am no expert and in the very early stages of learning excel vba. I would appreciate if you could provide any help on the following. Any suggestions of improvement of codes is always welcome too...

Hello Excel experts, I have been struggling for two days and I really need help from you. I am fairly new to VBA coding. I hope that I can find help here. I want to be able to gather a column from multiple workbooks in the same folder to a specific range of an existing Master workbook. A few...

How can I create a code that will compare sheets and replace another column when there is a unique identifier found. Sheet 1 and 2, column A will contain a unique ID but they wont be in the same order. Sheet 1 and 2 will have column B containing non-unique data. I need for sheet 1 column B to...

hi' i am trying to write a code in vb macro ,i am using below formula as Range("C3").Select ActiveCell.FormulaR1C1 = "=MID(R[-2]C,3,4)" Range("C3").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False...