View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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