View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default How to make a txtbox not visible

Something like....

If Len(Trim(Label1.Caption)) 0 then
TextBox1.Visible = True
Else
TextBox1.Visible = False
Endif


--
Cheers
Nigel



"Jennifer" wrote in message
...
Hello Hello,
How do i make a textbox only visible if the label has a value in it.
Example
might be in vba there are 10 labels and 10 textboxes. When i activate the
form and i have it only three labels fill with information i only want to
see
txtboxes 1,2,3, to be visible. Need lots of direction . . . thanks.
--
Thank you,

Jennifer