Hello all,

in the attached excel file i'm trying to the following (click the "analyse" button on the top right) :
clicking "genereer" does a first autofilter and generates a list of everything in that selection. With priorities on the left and projects on the right.
The 5 checkboxes on the left represent the options in column K, the 20 checkboxes on the right respresent the options in column D.

Now I want to give the user the possibility to show parts of that first selection. So they should be able to mark 1 or more checkboxes on the left and 1 or more checkboxes on the right and then click the "Toon" button and make the autofilter on the 2 columns (K and D) with those variables that were checked.


The code so far is situated under the form "Analyse".
Klusjes V2kopie.xlsm
My main problem is that I don't know how to tell excel if the checkbox is checked, use it to filter, otherwise don't.

Thanks in advance for all your help !