User form: with check boxes how do i allow MULTIPLE auto filters to run at the same time

Ok so basically i have a form in which I've assigned all my auto filters to a button, these auto filters run when a check box is clicked and then the button is pressed.

HOWEVER the only auto filter that runs is the latest one i assigned to the button.

1.png

For example in this image the SEND support auto filter is the only one which would run as it was the latest auto filter in my code.

Here's the code i assigned to the apply button, basically it's just a bunch of IF statements to see if each check box is ticked:

Please Login or Register  to view this content.

In a nutshell i want to be able to run all of the ticked auto filters at the same time, but cant really think of a way to do this, other than possibly creating about a billion IF statements

I cannot upload the actual sheet, sorry.

If it would help i could make a demo version

I really like that solution after having a play, the only problem is that it seems to be reliant on having at least one check box ticked in each frame for it to run, and ideally i'd want it to be able to run even if a frame of text boxes remained unticked.

Thanks, great solution