Macro to hide/unhide rows using more than one checkbox

Try the attached Excel file to see if it does what you need.
Checking the boxes has a cumulative effect of hiding rows where
the cell in the chosen column is blank. A command button is
included to unhide all rows and uncheck the checkboxes.
There is no code to support unchecking individual columns.

Please Login or Register  to view this content.

Be sure to add this code to a new module:

Please Login or Register  to view this content.

Hello xLJer,

Many thanks for your immediate and very detailed reply!

The example you uploaded is really close to what I need. I have taken some screenshots (attached word file) using your example to show exactly the desired sequence of results to be shown each time a checkbox is clicked (I just edited the fields over the results for illustration purposes).

I also tried to change a part of your code to the one below:

Please Login or Register  to view this content.

but unfortunately, it did not bring the desired result.

Again, thanks a lot, I really appreciate you help on this!!!
You've been already really helpful!

Dear xLJer,

I honestly have no words to say thank you for this! It was just what I needed! Spot on!

I replaced the For loop code and it works perfectly!!!

Thanks a lot!!!

Dear xLJer,

The code works perfectly and I would like to move the whole part more to the right. The problem is that the code is already set for the rows below:

Please Login or Register  to view this content.

while I need to make it work for the rows X,Y,Z,AA,AB,AC,AD,AE,AF,AG,AH,AI,AJ,AK and AL.

I tried the code below:

Please Login or Register  to view this content.

but it does not seem to work.

Do you have any idea how I could overcome this problem?

Thank you in advance.

xLJer,

Your code works 100%!

I received a lot of help from you! Many thanks to the Excel Forum site and to you xLJer!

Best Regards