User form listbox filter

[Kurt Smart]

Hi all,

I have a listbox (listbox) that displays a sheet columns a to v (1 to 23). I have buttons that I'd like to apply a filter to 2 columns.

So user clicks the button then if column 18 equals Y and 19 equals blank display the filtered results in my listbox1

 

[Eloise T]

I would be easier if you could upload a sample....how it looks now, and what you want it to look like after the macro has performed its magic.

 

[Kurt Smart]

ok yes no problem... its column 16 and 17.... so 16 has to equal Y and 17 to be blank

 

[Belleke]

Like This?
See attached

 

[Kurt Smart]

Hi i think this is it...
Could you explain what the lines of code are doing for a Newbie

 

[Eloise T]

This is a good place to reference, both now and later:

www.excelfunctions.net

Pay close attention to the right column where you can select functions alphabetically: