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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Userform textbox string to header causes unwanted double spacing 4
Format year problem 1
Format year problem 2
Textbox Enabled but not where you can type in it 1
Bold certain text in textbox 1
Having data populate text boxes based on Combobox Value 1
Validate Textbox/Userform Number Range 2

Back
Top