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

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

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

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
.