Thread: reverse a "hide" function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default 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

Reply With QuoteReply With Quote