userform text boxes

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

Hi
Yes me again, thanks for all the help.
I have 2 userforms, the 2nd of which is partly populated
from the selections of the first. I wish to use an answer
from the first userform to make some of the text boxes on
the second form either read-only or editable (is that a
word?).
I am thinking I could somehow set the tag property
to "this box" and use that to select those boxes I want
read-only.
My problem lies in that I do not know how to make the
boxes read-only.
Thanks again in advance
Jo
 
Jo,

Put this in your code:

Userform1.TextBox1.Enabled = True
to allow entry. Set to False to make it "read only"
 
Also, look at the locked property.

Enabled = False

and
Locked = True

will both keep it from being edited, but will have different visual effects.
 
Back
Top