Using ComboBox on Userform to filter ListBox

Hello burger160,

This was quite a challenge. Good news it that the attached workbook is functioning correctly.

At the top of each ComboBox is the choice "Select All" which allows the user to remove the filtering on that column only. The remaining filters are unaffected.

The ComboBox will change color from white (Select All) to Yellow (filter choice). This provides a visual indicator to the user which columns have filtering applied.

Each Combox lists the unique entires for it's column in ascending alphabetical order. Each time a choice is made the ListBox is updated.

Try this out and let me know what you think about it.


Here is the code for the macro to sort the ComboBox.

Sort And Remove Duplicates From CombBox Macro Code

Please Login or Register  to view this content.

Hello burger160,

After a little testing I found a problem. A single row would not display correctly. I fixed that problem and also reduced the flickering when the UserForm is loading.

NOTE: Please use this version of the workbook for testing and evaluation.

Hi burger160

As did Leith, I found this to be a bit of a challenge. As I've spent considerable time on the effort I'm offering a proposed solution to MY intrepretation of the issue as you described it.

Ideally, I would like all products to appear in the ListBox to begin with

and this

based on a selection made in any or all of the ComboBox, I would like it to then filter the ListBox to critera that is selected

I acknowledge, my interpretation of the issue may be way off base. But, there you go.