I want to use a a groups of checkboxes in conjunction with the autofilter function in Excel. I can see plenty of examples of code to set up the autofilter where the criteria are being written into a worksheet but nothing similar to my needs.
I have a group of 9 checkboxes to be used against column K and a couple more groups on other columns. In each group any one or any number of the checkboxes can be selected.
Can someone give me a steer on dealing with this variable number of criteria in VBA please?
Thanks
Geoff
I have a group of 9 checkboxes to be used against column K and a couple more groups on other columns. In each group any one or any number of the checkboxes can be selected.
Can someone give me a steer on dealing with this variable number of criteria in VBA please?
Thanks
Geoff