reverse a "hide" function

[DarrenL]

Current code:

Private Sub CheckBox1_Click()
Range("A10:A28").EntireRow.Hidden = CheckBox1.Value
End Sub

I need to reverse the checkbox. Currently, when it is checked, the rows hide.
I need it to do the opposite.
Anyone?
Thanks
D

 

[Joel]

Use NOT

Private Sub CheckBox1_Click()
Range("A10:A28").EntireRow.Hidden = not CheckBox1.Value
End Sub

 

[DarrenL]

Awesome. Thanks. Had a feeling it was going to be really simple.