Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The visible property does indeed make the control visible/invisible. It has
no effect on the text. Not sure what you could be doing wrong as it's very straightforward. Setting the property from the properties menu should do the trick. If you're doing it via code perhaps you are mis-spelling the property (I noticed your spelling of visible) however that should generate an error. -- Regards, Bill Lunney www.billlunney.com "Robin D" wrote in message ... Can you hide a textbox on a userform? I tried playing with the visable property... but I think that is talking about the text within the textbox. any ideas? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() That did the trick -- Bad spelling will get you every time. Good thing I'm not a doctor! Thanks! -----Original Message----- The visible property does indeed make the control visible/invisible. It has no effect on the text. Not sure what you could be doing wrong as it's very straightforward. Setting the property from the properties menu should do the trick. If you're doing it via code perhaps you are mis-spelling the property (I noticed your spelling of visible) however that should generate an error. -- Regards, Bill Lunney www.billlunney.com "Robin D" wrote in message ... Can you hide a textbox on a userform? I tried playing with the visable property... but I think that is talking about the text within the textbox. any ideas? . |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
Father-to-son speech coming up <g: Always use "require variable declaration" (Tools Options menu in the VBE). This will put "Option Explicit" on all code modules and force you to declare everything. More work, better habits and far more efficient code that use less memory and time to run. One nice effect of this setting is that misspellings will produce errors, the debugger will spot them and take you right there with some information on what's wrong. -- HTH. Best wishes Harald Excel MVP Followup to newsgroup only please. "robinD" wrote in message ... That did the trick -- Bad spelling will get you every time. Good thing I'm not a doctor! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add COUNTIF TO USERFORM TEXTBOX | Excel Worksheet Functions | |||
userform textbox | Excel Worksheet Functions | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Help with Syntax UserForm TextBox | Excel Programming | |||
Populating Textbox in UserForm | Excel Programming |