Hello,
I have the following userform code which just populates a listbox with data from a table:
I am needing to amend the code so that it only adds the data that matches a certain criteria, so I only want the data included that has a certain value in column J.Private Sub UserForm_Initialize() With Listbox1 .ColumnCount = 10 .List = Sheets("Data").Range("Table1").Value End With End Sub
How do I do this please?
Bookmarks