Greying out(disabling) textbox from being typed in

[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

 

[Don Guillett]

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

 

[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?

 

[Todd Huttenstine]

Thank you. That worked.