Toggle button

[keithl816]

Hello,

I have toggle buttons on a spreadsheet that opens hidden spreadsheets
when not in use. These sheets are just for correction purposes, so to
keep from having so many spreadsheets on the bottom bar, I hide them.
Is it possible to change the title in the button when the button is
depressed? I want the button to show DISPLAY when out and HIDE when
depressed.

Any help would be appreciated.

Larry

 

[twox4s]

Insert this code with the appropriate name changes into the click event
of your button.
Private Sub ToggleButton1_Click()

MsgBox ToggleButton1.Value
If ToggleButton1.Value = True Then
ToggleButton1.Caption = "Hide"
Else
ToggleButton1.Caption = "Display"
End If

End Sub

 

[keithl816]

Hi twox4s,

Thanks for the reply. That worked great!!!!

Thanks again.

Larry