UserForms for filtering multiple categories

[emanon132501]

Hi,

I'm a beginner and need help to get me started in a project that I'm doing. In the attached file i have a list of fruits in Column A. I would like to create a userform with multiple checkboxes of the fruit names and would like to filter Column A based on what fruits were checked on the userform.

Any help will be highly appreciated.

Thanks

[MaczaQ]

hi,

Check my solution besed on Autofilter.

Best Regards

[emanon132501]

Thanks for the swift reply maczaq, can i see an example of having the ability to choose more than one fruit? i.e. filter showing both apples and oranges

[MaczaQ]

try now, I implemented 2 criteria filter.

Best Regards

[emanon132501]

I LOVE IT!

Thank You Very Much!!!

[MaczaQ]

consider to mark this thread as SOLVED.

I will be pleasent if you add me some reputation points for help.

Best Regards
MaczaQ