Welcome to Code Forum!

Join a community that supports you and your coding journey from day one. We strive to be a friendly, supportive community that empowers everyone to be better developers. 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