Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a toggle box set up with the following formula
Private Sub ToggleButton10_Click() With Me.ToggleButton10 If .Value = False Then .ForeColor = &H0 Else .ForeColor = &HFFFFFF End If End With End Sub Is it possible to make the toggle box print only if the value is true? Thanks in advance for any help |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi John,
Try: Private Sub ToggleButton1_Click() With Me.ToggleButton1 If .Value = False Then .ForeColor = &H0 .PrintObject = False Else .ForeColor = &HFFFFFF .PrintObject = True End If End With End Sub -- --- Regards, Norman "John Davies" wrote in message ... I have a toggle box set up with the following formula Private Sub ToggleButton10_Click() With Me.ToggleButton10 If .Value = False Then .ForeColor = &H0 Else .ForeColor = &HFFFFFF End If End With End Sub Is it possible to make the toggle box print only if the value is true? Thanks in advance for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
Checkbox toggle true/false | Excel Programming | |||
Print Orientation Toggle | Excel Programming | |||
Toggle True/False in a cell | Excel Programming |