reverse a "hide" function

D

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
 
J

Joel

Use NOT

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to have 2 drop down lists filter rows 2
Execute a macro automatically when checkbox is clicked 3
hiding rows containing formulas which return zero values 3
Hide rows issue 3
I could use some help on a modification... 3
Make a formula work with a checkbox 3
Help needed editing a script 5
Hide rows using VBA based on cell value 0

Top