userform text boxes
 

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

userform text boxes
 

Jo,

Put this in your code:

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

--
sb
"Jo" wrote in message
...
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

userform text boxes
 

Jo,

Textbox1.Enabled = False
or
Textbox1.Locked = True

John

Jo wrote:

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

userform text boxes
 

Also, look at the locked property.

Enabled = False

and
Locked = True

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

--
Regards,
Tom Ogilvy

Jo wrote in message
...
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

userform text boxes
 

Tom,

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

John

"Tom Ogilvy" wrote in message
...
Also, look at the locked property.

Enabled = False

and
Locked = True

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

--
Regards,
Tom Ogilvy

Jo wrote in message
...
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