Thread: Hide a text box
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Hide a text box

Try Martin Green's page at:
http://www.fontstuff.com/ebooks/eboo...ontent.htm#msg

Download his sample file :
RecordingExcelMacros.zip [19 KB]

On each sheet in the sample file, he demos how it's done
using Form toolbar buttons: "Show/Hide Explanation"
Look for his sub in VBE: Sub ShowHideTextBox
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Orf Bartrop" wrote:
Well, if I can't hide a text box how else could I create some
instructions that can be turned on or off?

Orf

SteveW wrote:

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

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