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 |