How to filtering in a userform

[fraz627]

I have a userform which uses a list box with multiple columns, what would be the best way to filter the rows, based on the selection of another column.

any advice is helpful.

[Tinbendr]

You can't 'filter' a listbox. You can only put the items you want in it.

Ways to accomplish this.

1. You can loop through the listbox, looking for the items you want, store them in a array, then replace the entries in the listbox.

2. Use Range.Find and search for the items on the worksheet, adding them as a match is found.

3. Use cascading comboboxes. Choose a unique item from Column1, then display only those matching items in a second combobox, etc until you narrow the selection down.