I have a userform with checkboxes. Based on those checkboxes, I want my data to filter to show what is checked as the criteria.
<tbody>
</tbody>
For example, if Green,Small, and New were checked, it would give me the second apple and the second banana records. Each column has a set of check boxes. As in the example, not all columns must have a selection to filter the data.
What is the best way to check all the check box values and filter based on that? I understand that an advanced filter would work, but I dont want to create lots of "if" statements to filter. Is there a way to keep filtering the data as the code is cycling through the check boxes?
Apple | Red | Large | New |
Apple | Green | Small | New |
Apple | Red | Small | Old |
Banana | Yellow | Large | New |
Banana | Green | Small | New |
<tbody>
</tbody>
For example, if Green,Small, and New were checked, it would give me the second apple and the second banana records. Each column has a set of check boxes. As in the example, not all columns must have a selection to filter the data.
What is the best way to check all the check box values and filter based on that? I understand that an advanced filter would work, but I dont want to create lots of "if" statements to filter. Is there a way to keep filtering the data as the code is cycling through the check boxes?