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 Userform resizing

Userforms have height and width properties. Your controls can be "off the
sheet" so to speak, and to make them visible increase the height or width
(or both ) to include them.

--
Regards,
Tom Ogilvy

"lmarks" wrote in message
...
Hello Group

What I would like to know - is there a way to automatically resize a
userform, or do I need to create lots of userforms to workround. For
instance, I have controls that are set visible=false inside a frame but
obviously when the userform first shows there is an awful lot of grey for
the user, "looks=tacky!"

Thanks as always in advance to this excellent group.
Mark