View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Beto[_3_] Beto[_3_] is offline
external usenet poster
 
Posts: 140
Default Where to put code

Matt wrote:

I want some check boxes to be visible based on whether
another check box is selected. This is the code that I
have, I just am not sure where to put it. Thanks.

Private Sub Checkbox3_Select()
If Checkbox3.Value = False Then
Checkbox30.Visible = False
Checkbox31.Visible = False
Checkbox32.Visible = False
Checkbox33.Visible = False
Checkbox39.Visible = False
Checkbox40.Visible = False
Checkbox41.Visible = False
End If
End Sub


In Excel, Right-click on the tab sheet and choose View Code. There you
have to put your code.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.