Greying out(disabling) textbox from being typed in

T

Todd Huttenstine

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
 
D

Don Guillett

In properties the default is locked which will take effect upon protecting
the sheet.
 
M

Michael Hopwood

MyForm.Textbox1.Locked = True

If you don't want it to be edited ever, why not use a label instead of a
textbox?
 
Top