ExcelBanter - reverse a "hide" function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - reverse a "hide" function (https://www.excelbanter.com/excel-programming/429901-reverse-hide-function.html)

DarrenL

reverse a "hide" function

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

reverse a "hide" function

Use NOT

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

"DarrenL" wrote:

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

DarrenL

reverse a "hide" function

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

"Joel" wrote:

Use NOT

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

"DarrenL" wrote:

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

All times are GMT +1. The time now is 05:37 PM.