View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Davies John Davies is offline
external usenet poster
 
Posts: 39
Default toggle box print if value is true

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