How to show/hide sections of a userform?
 

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 textbo
to appear underneath for more info

--
madblok
-----------------------------------------------------------------------
madbloke's Profile: http://www.excelforum.com/member.php...fo&userid=1442
View this thread: http://www.excelforum.com/showthread.php?threadid=26686

How to show/hide sections of a userform?
 

You can make a userform that has a height of 100 for example. Then either
in design mode or the initialize event, set the height to 50 (as an
example). Before doing that, put your textbox beyond 50. Now, in the click
event of the checkbox adjust the height of the userform

if Checkbox1 then
userform1.Height = 100
else
userform1.Height = 50
End if

--
Regards,
Tom Ogilvy

"madbloke" wrote in 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...o&userid=14422
View this thread: http://www.excelforum.com/showthread...hreadid=266861

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

.