Thread: Hide a text box
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Orf Bartrop Orf Bartrop is offline
external usenet poster
 
Posts: 21
Default Hide a text box

What I have been trying with no luck is:

Private Sub ToggleButton62_Click()
If ToggleButton62.Value = True Then
TextBox63.HideSelection = False
ToggleButton62.Caption = "Selection Visible"
Else
TextBox63.HideSelection = True
ToggleButton62.Caption = "Selection Hidden"
End If
End Sub

It stops on the If line.

Orf
Orf Bartrop wrote:

On sheet 3 of my workbook I have created a button (button 62) and a
text box (textbox 63).
What I want to do is use the button to toggle the text box on and off.
By that I want to be able to show the box or hide the box.
I have tried to copy code from the MS Visual Basic Help but it did not
work, basically because I have no idea what I am doing.
Can someone lease help?

Orf Bartrop