Filter listbox

[miami2k]

Dear All,

I'm looking for a simple code to filter a the rows in a listbox depending on a checkbox or combobox.

The list is populated with the following kind of command:
Me.ListBox1.RowSource = ListRange.Address

Now for example I want to flag the checkbox and I want the listbox to show only the rows in which column D is empty.


Thank you in advance!

miami2k

 

[MrIfOnly]

Have a look at this thread: https://www.mrexcel.com/forum/excel-questions/1002130-multicolumn-listbox.html

With some modification, you should be able to use my code in post 6 to do what you want.

Regards,

CJ

 

[miami2k]

What can I say? Fantastic! Thank you.
I've tried on a simple file and it works perfectly. I'll try to adapt it to my project and I might get back with more questions!