Show/Hide Range of Cells Using Multiple Checkboxes

Hi!

I have a sheet with 7 different check boxes. Each check box refers to a different range of cells. I need to create a sheet where if one box is checked, everything else is hidden. However the user needs to be able to check multiple boxes and have each range of assigned cells showing.

Example:

Checkbox 1 = only rows 30 - 69. Checkbox 2 = only rows 70 - 98. Checkbox 3 = only rows 99 - 130. I need to make it so if you click on checkbox 1, you'll only see rows 30 - 69. However if you click on Checkbox 1 and Checkbox 2, you'll see rows 30 - 70. If you click Checkbox 1 and Checkbox 3, then you can see rows 30 - 69 and rows 99 -130, but rows 70 - 98 remain hidden.

Any assistance would be greatly appreciated.

Thanks!

Code in this way for all checkboxes with respect to their related rows:

Please Login or Register  to view this content.

Hi hafizimran,

Perhaps I'm missing something obvious, but I keep getting a 424 error "object required". When I run debug, it highlights this part of your code:

Please Login or Register  to view this content.

I've tried renaming CheckBox1 as the title I gave my checkbox, but no dice. Any thoughts?

Thanks!

That might be the problem. I've been using form controls, not active X and creating modules in the code.