View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Helen Trim[_4_] Helen Trim[_4_] is offline
external usenet poster
 
Posts: 16
Default How to show/hide sections of a userform?


Everything on a userform has a Visible property. To show
a textbox when a check box is ticked, use:

Private Sub CheckBox1_Click()

CommandButton1.Visible = CheckBox1.Value

End Sub


-----Original Message-----

How would I go about doing this (if it's even possible)?

For example, if someone checks a checkbox on my form, I

want a textbox
to appear underneath for more info.


--
madbloke
----------------------------------------------------------

--------------
madbloke's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=14422
View this thread:

http://www.excelforum.com/showthread...hreadid=266861

.