Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!

vba

  1. N

    Add the value taken from the user to my range for ActiveX ComboBox

    Hi everyone, I defined a ActiveX ComboBox named "cmbPeymankar", a Text Box (ActiveX control) called "txtNewPeymankar". a Command Button (ActiveX control) called "Add". I have a table named "Table1" in sheet "DATA" so that the first column of Table1 contains the names that should be displayed...
  2. J

    Help Needed in VBA

    I am new to VBA and this is the first Macro I've tried to write. I have an excel table which has five columns titled Address, location , works , action and completed. I want to create a new worksheet for each unique address and then copy the relevant rows for that address on that new worksheet...
  3. L

    VBA Mail-merge Date format inconsistencies

    I have a spreadsheet that I am using to mail-merge with a Word template document. The mail merge is triggered by VBA code. I have some dates which come out correctly in the mail-merge and others that show incorrectly. The Word-doc merge field is formatted thus: {MERGEFIELD DUE@"dd MMM yyyy...
  4. M

    Adding Row to the Below Active cell when condition is met

    I have created below code which works like IF Col"B" any cell <> "" And Col"L" any cell = "Leop" then add row below to the active cell. But an error is appear. Compile Error: Invalid use of property Your help will be appreciated. Sub firstcondition() Dim ws As Worksheet Dim LRow As...
Back
Top Bottom