Rows to hide/unhide when checkbox = true/false

[PDBartlett]

Hello

I have 10 checkboxes on a sheet called 'Coversheet'

When let's say the first one is checked, I need row 26 on "Dashboard" to unhide, and vice versa

Here is my code so far which isn't working:

Please Login or Register  to view this content.

Note, my checkboxes aren't Active X

Thanks!

[Winon]

Hello PDBartlett,

Given your sample, I assume you have something in mind as per the attached sample.

Regards.

[HaHoBe]

Hi, PDBartlett,

Please Login or Register  to view this content.

Ciao,
Holger

[fsalina]

Please Login or Register  to view this content.

[PDBartlett]

Thanks Winon, works perfectly! Is there any way of shortening the code as I be adding more checkboxes?

Fsalina that's just the code I posted?

[Winon]

Hello PDBartlett,

Thank you for the feedback.

Unfortunately I cannot think of a way to make it any shorter as shown in the revised attachment.

Regards.

[HaHoBe]

Hi, PDBartlett,

Is there any way of shortening the code as I be adding more checkboxes?

There is a way but thatīs needing ActiveX components AFAIK: class programming. And I would prefer one UserForm handling all the action over a lot of CheckBoxes with their individual codes

Maybe consider to get hold of the row where the checkbox is located to hide/unhide on the other sheet.

Please Login or Register  to view this content.

Ciao,
Holger

[PDBartlett]

No worries, thanks for your help

[Winon]

Hello PDBartlett,

If you want to trade the CheckBoxes for DropDown Boxes, it would work as demonstrated in the attached sample Workbook.

I am also sure that you have marked this thread as Solved, with the excellent contribution from HaHoBe.

Also, since you are relatively new to the forum, I would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which you have been helped.

This adds to the reputation of the person/s who has taken the time to help you.

Best Regards.

[PDBartlett]

I've stuck with your initial code, Winon, but could you help me with this:

I've added the following code to uncheck all checkboxes:

Please Login or Register  to view this content.

But when it runs, the rows that should then hide because the checkboxes aren't ticked aren't hidden.. they just don't do anything?

I don't understand why

[Winon]

Hi PDBartlett,

Thanks for the feedback.

With the sample Workbook as per Post#6.

If you want to clear the Checkboxes, you have to tell VBA to keep the hidden Rows in the Dashboard Sheet as is, as follows:

Please Login or Register  to view this content.

Regards.

[PDBartlett]

Hi Winon

Thanks for that.

The code I now have works if all the checkboxes are selected, but if only a few are selected and I run the macro, I get the message:

Unable to set the Hidden property of the Range class

My code:

Please Login or Register  to view this content.

Would it be some kind of If statement?

[PDBartlett]

Hi Winon

Thanks for that.

The code I now have works if all the checkboxes are selected, but if only a few are selected and I run the macro, I get the message:

Unable to set the Hidden property of the Range class

My code:

Please Login or Register  to view this content.

Would it be some kind of If statement?

[Winon]

Hi PDBartlett,

Have you not perhaps protected the Sheets? If it is the case then change your code:

Please Login or Register  to view this content.

Regards

[PDBartlett]

Excellent! So simple haha

Think I can mark this as solved now, thanks for your help

[Winon]

Hello PDBartlett,


Thank you for the feedback.

You are welcome, glad I could help.

Regards.