View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default 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