Filter UserForm Multicolumn ListBox. populated by RowSource. with TextBox/ComboBox

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.

Alex,

Unless I'm very much mistaken you started the same thread yesterday?

You cannot remove items from the listbox if you use a rowsource... instead you'd have to populate the combobox by code (for example in the userform initialize code). Then you would be able to remove items from it.

Yes you can dynamically set columns... it is the .ColumnCount property of the listbox.... I'll post a snippet of code that can hopefully point you in the right direction...

Please Login or Register  to view this content.

I should have added that the column widths could be a pain to set if it is dynamic... but if they are all the same width you could use this loop.... you could also ammend it to do specific widths for specific column numbers

Please Login or Register  to view this content.