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