userform text boxes

[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

 

[steve]

Jo,

Put this in your code:

Userform1.TextBox1.Enabled = True
to allow entry. Set to False to make it "read only"

 

[John Wilson]

Jo,

Textbox1.Enabled = False
or
Textbox1.Locked = True

John

 

[Tom Ogilvy]

Also, look at the locked property.

Enabled = False

and
Locked = True

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

 

[John Wilson]

Tom,

I thought I said that.
Unless my post didn't come up in your newsreader??

John