Filter UserForm Multicolumn ListBox with TextBox/ComboBox

**Alex.riccio** · 12-06-2016, 03:34 PM

Hi Everyone,

I've been looking for an answer to this specific scenario and I haven't found it yet. If it exists, I'm sorry for wasting your time and would request the link to that answer please.

If not, here we go.

I'm creating a listbox in a userform that's using a rowsource from a sheet to list the multicolumn list.

This list is very big and I want to be able to filter through it using a combobox to specify which column to filter by and a textbox to specify the keywords to filter by.

I've found different iterations of these in pieces but not as a whole and I haven't been able to put it together.

Here is the code I have so far:

Please Login or Register  to view this content.

I get a "Unspecified Error" (80004005) When I get to the ".RemoveItem i" line which I've read is because I'm using RowSource to populate the list.

Is there an easier what to achieve all this?

Thank you for your help and let me know if you need more information.

**Norie** · 12-06-2016, 03:40 PM

If you use RowSource to populate a listbox you can't remove items from it.

**Arkadi** · 12-06-2016, 04:31 PM

Instead of using a rowsource you'd have to populate the listbox via code (for example in the userform initialization) if you want to remove items from it later.