I have seven checkboxes on a cover sheet that change the values to true/false on a separate sheet (I am not sure the difference between the ActiveX checkboxes and the normal Design mode checkboxes). When I click a button to apply the filters (after the checkboxes are selected) the filter should make multiple filters based on the checkboxes. This filtering is done on a separate tab. I can only get it to do one filter at a time. Is there a way to do this without having a massive If statement for every single combination of checkboxes?
The greened out code only filters the last IF statement checked:
The non-greened code doesn't work. It runs but does not recognize the nameVar variables as having names in them.
Bookmarks