Locking a TextBox in a userform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to lock a text box in a UserForm i made. This Box is returning data
and i dont want the user to be able to change the values. I could not find
an option taht looked like it would Disallow user input into the box. Is
there such and option? Or maybe another way to do this using a different
type of tool?
 
Hi,

You could set the Locked property to True in the Properties box.

Or do it programmatically:

TextBox1.Locked = True
 
Thanks!
I cant believe i didnt see that option, but that was exactly what i was
looking for. Thanks again

CSUS_CE_Student
 
Wouldn't it be more common to use a Label?

CSUS_CE_Student said:
I want to lock a text box in a UserForm i made. This Box is returning data
and i dont want the user to be able to change the values. I could not find
an option taht looked like it would Disallow user input into the box. Is
there such and option? Or maybe another way to do this using a different
type of tool?
Click to expand...
 
Back
Top