Hide a text box

  • Thread starter Thread starter Orf Bartrop
  • Start date Start date
O

Orf Bartrop

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
 
Under my Excel - 2000
I don't think you can hide a text box
But I hope Im wrong it would be a good idea

Steve
 
Well, if I can't hide a text box how else could I create some
instructions that can be turned on or off?

Orf
 
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
 
Try this with a button created from the View > Toolbars > Forms menu, right
click and assign this macro to the button,

Sub ToggleTextBox()
If ActiveSheet.Shapes("Text Box 63").Visible = True Then
ActiveSheet.Shapes("Text Box 63").Visible = False
Else
ActiveSheet.Shapes("Text Box 63").Visible = True
End If
End Sub

Regards,
Alan.
 
Thanks to one and all for your help. I used your code Alan and it did
the job - thanks.
Orf
 
Back
Top