| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Greying out(disabling) textbox from being typed in
How do you Grey out(disable) a textbox from being typed
in? I have Textbox1 display the value of a cell on the spreadsheet but I dont want the user to be able to click and type in the textbox. What would the code be for this? Thank you Todd Huttenstine |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Greying out(disabling) textbox from being typed in
In properties the default is locked which will take effect upon protecting
the sheet. -- Don Guillett SalesAid Software "Todd Huttenstine" wrote in message ... How do you Grey out(disable) a textbox from being typed in? I have Textbox1 display the value of a cell on the spreadsheet but I dont want the user to be able to click and type in the textbox. What would the code be for this? Thank you Todd Huttenstine |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Greying out(disabling) textbox from being typed in
MyForm.Textbox1.Locked = True
If you don't want it to be edited ever, why not use a label instead of a textbox? -- Michael Hopwood (Phobos) "Todd Huttenstine" wrote in message ... How do you Grey out(disable) a textbox from being typed in? I have Textbox1 display the value of a cell on the spreadsheet but I dont want the user to be able to click and type in the textbox. What would the code be for this? Thank you Todd Huttenstine |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Greying out(disabling) textbox from being typed in
Thank you. That worked.
-----Original Message----- How do you Grey out(disable) a textbox from being typed in? I have Textbox1 display the value of a cell on the spreadsheet but I dont want the user to be able to click and type in the textbox. What would the code be for this? Thank you Todd Huttenstine . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
| Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
| Greying out text | Excel Discussion (Misc queries) | |||
| Greying out or locking certain columns | Excel Discussion (Misc queries) | |||
| UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
![Todd Huttenstine[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
