Hi guys, I'm a noob :-( and have a question:

I'm trying to use optionbuttons in a user form to filter a table in a worksheet. The filter has about 20 criteria and I have created optionbuttons in individual frames within a userform that allows multiple options to be checked. My question is, what code do I use to ensure the correct filters are selected that correspond with the checked option buttons?

I am using the following code:
Please Login or Register  to view this content.
So when I select "Criteria 1" and "Criteria 2", only Criteria 2 will be selected because the second line of code is deselecting Criteria 1.

Is there an efficient way to do this? The 20 criteria can appear in any combination.

Thanks for your help!