Multiple checkboxes & hide unhide rows

[janomm]

Hello,
I've looked a lot in the different threads related to checkboxes or unhide row but didn't found an answer that allowed me to do what I need to.

My question is how to proceed in VBA to structure the following events:
Row 1 is visible. In R1C1 is a checkboxA. Clicking checkboxA unhide row 2. In R2C1 is a checkboxB. Clicking checkboxB unhide row 3.

Row 4 is visible. In R4C1 is a checkbox C. Clicking checkboxC unhide row 5. In R5C1 is a checkboxD. Clicking checkboxD unhide row 6.

Row 7 is visible. In R7C1 is a checkb...

Unclicking the checkboxes hides the corresponding row triggered by the corresponding checkbox. This is above my league and that's why I need help.

With a demanding boss who is regularly breathing in my neck...
Tnx in advance

 

[HalfAce]

Not knowing what version of excel you're using, or where these checkboxes came from (I'm assuming they're activeX checkboxes - from the Controls Toolbox toolbar),
here's something you can try:

Private Sub CheckBoxA_Click()
Rows(2).EntireRow.Hidden = Not CheckBoxA
End Sub

Private Sub CheckBoxB_Click()
Rows(3).EntireRow.Hidden = Not CheckBoxB
End Sub

and so on...

Does that help?

 

[wigi]

HalfAce: EntireRow is not needed

 

[janomm]

Seing the answer makes il always look so simple.
Nevertheless Tnx again.