Locking a TextBox in a userform

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

Guest

Hi,

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

Or do it programmatically:

TextBox1.Locked = True
 
G

Guest

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

CSUS_CE_Student
 
D

Dave Peterson

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...
 

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

userform textbox returns changeable date 4
Userform textbox string to header causes unwanted double spacing 4
Userform Textbox to Worksheet Textbox 1
Using a TextBox in a Userform 1
display special characters in some textbox fields to ensure data f 1
display $ in a userform textbox 2
Paste into spreadsheet in userform 2
WordWrap in TextBox on a UserForm 2

Top