crow

Hi friends, I have created a workbook of 6 sheets who's VBA code I have writted is, Sub CopyDataBasedOnStatusCondtion() Dim lRow, cRow As Long lRow = Sheets("Sheet1").Range("A50000").End(xlUp).Row For j = lRow To 1 Step -1 If Sheets("Sheet1").Range("B" & j) = "9265553826"...

Preface: I’m brand new to VBA and have no other coding experience. I started creating a macro to do some routine formatting on an excel sheet I export regularly. I’m looking to count rows with a certain condition and then provide a message box with the count and a brief message. This is what I...

Hi All, As per the title, I would like to do a quick check to see if the variable 'Society' is already within my cbSociety (ComboBox) if not, then add. Private Sub UserForm_Initialize()Dim ws As Worksheet Set ws = Worksheets("Trials") cRow = 2 While ws.Cells(cRow, 2) <> "" Society =...

I know this is pretty simple. I have a form with 2 textboxes (ID"ColA", Email"ColC") and a combobox (Group"ColB") I want to populate a listbox items with a combobox change event. Everytime the change event fires, the listbox goes blank but I can still select the row data in the listbox, however...