VBA AutoFilter With List Boxes

Occasional Contributor

In this template, we filtered the data in the worksheet with list boxes on userform . We filled the data of the 3 columns that we selected into the list boxes as unique and sorted values. The selected item from the listbox is displayed on the textbox, the AutoFilter method is triggered according to value of this textbox.

 

Excel-autofilter-userform-P.gif

 

Source codes, sample file here

0 Replies