Hello,

I have the following userform code which just populates a listbox with data from a table:

Private Sub UserForm_Initialize()
With Listbox1
        .ColumnCount = 10
        .List = Sheets("Data").Range("Table1").Value
    End With
End Sub
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.

How do I do this please?