Greyed Boxed on userform

[jaypatel]

Hi all,

I have on my userform a text box.
I have 2 questions.

The first is how do i make it all greyed out.
The second is, how do i make that same box not enterable, so no one can edit or enter any information in that box.

Cheers

Jay

 

[TommyGun]

You will need to edit the properties of the textbox.

1. To "gray" the textbox, set the Enabled property to False.
2. To disallow the user to enter information, set the Locked property to True.