ListBox Column Filter

[jstevens]

Is it possible to apply a filter to a ListBox column?

[HansV]

Please explain in more detail what you want to do.

[jstevens]

I have a listbox with a number of columns, one (Status) which contains the text "favorable or unfavorable". I would like to filter on the Status column to show all favorable, unfavorable records or both.

[HansV]

If the RowSource of the combo box is a range on a worksheet, you'd have to extract the filtered records to a separate range, and set that as RowSource.
Alternatively, populate the list box using AddItem. I have attached an example of that approach.

Testfile.xlsm

[jstevens]

Hans,

Very nice.

Thank you.

[snb]

Example