filter listbox without rowsource

Hi there,

I'm working on a database and managed to put together a macro that searches the active sheet and presents all matching registrations in a multicolumn listbox. However, the database will eventually contain over a thousand entries, so I'd like to install one or more filters; that is, I'd like a macro to conditionally remove rows from the listbox when the value in the second cilumn does not match the value in another list or textbox. There are several examples of such filters available on the web, but they all seem to be using listboxes filled with the rowsource property, and the listbox in my file is filled using vb (.AddItem, file attached).

I'd be very happy if anyone would provide me with a code that filters the searchresults in the listbox directly, without transferring data to or from sheets. Thanks in advance.

Originally Posted by royUK

Maybe using RemoveItem method - see VBA help files

thanks for your response; the RemoveItem method does seem to be the answer. However, I can't use an If-statement within an If Not/Else block, so how could I make the RemoveItem dependant on the value in column 5?