Thread: Toggle Button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Toggle Button

Private Sub ToggleButton1_Click()
If ToggleButton1.Value Then
ToggleButton1.Caption = "On"
Else
ToggleButton1.Caption = "Off"
End If
End Sub

--
Regards,
Tom Ogilvy

"Ben E" wrote in message
...


Hi All,
I'm trying to change the text on the face of a toggle
button when activated, i.e.: it will Switch between On &
Off when activated.

Any help would be appreciated.

Ben E