Greying out(disabling) textbox from being typed in

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
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
 
In properties the default is locked which will take effect upon protecting
the sheet.
 
MyForm.Textbox1.Locked = True

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