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

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