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