View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Memphis[_2_] Memphis[_2_] is offline
external usenet poster
 
Posts: 6
Default Changing page height while in a multipage

Hello guys,
I have a UserForm with a Multipage, this multipage has 10 pages.
I would like to cnahge the Height of only one page (Page3) from 400 to 200
while I am visiting this page and revert to 400 when I visit any of the other
pages.
You see, the other pages have lots of txt boxes and lbls, but Page3 has only
a handful of txt and lbls and I would like to shrink its height.

I can do this by clicking on a command button, but would like to have it
happen automatically for the user.

Thank you