Thread: Can you hide forms checkboxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Can you hide forms checkboxes
Hi Matt

I advise you to use the checkboxes from the control toolbox.
You have much more control then.

You can use this in the Sheet module

Private Sub CheckBox1_Click()
If Me.CheckBox1.Value = True Then
Me.CheckBox2.Visible = False
Else
Me.CheckBox2.Visible = True
End If
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Matt" wrote in message ...
Can you hide forms checkboxes based on whether another forms checkbox is selected? If so, where do I need to put the
code(Worksheet or Workbook)? Thanks.


Reply With QuoteReply With Quote