| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to put code
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where to put code
My question is first, is this code right, and then, do I put this in the Worksheet code or the workbook code. Thanks.
----- Beto wrote: ----- 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
| copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
Linear Mode
