View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
darryl26 darryl26 is offline
external usenet poster
 
Posts: 3
Default Sizing a UserForm

It actually already has a mulitpage which itself has a multipage on it.

"Jim Rech" wrote:

That's a very BIG userform. I think you should use a MultiPage control to
divide up your userform into several pages, if at all possible.

--
Jim Rech
Excel MVP
"darryl26" wrote in message
...
| Is there a way to have a userform sized to fit the user's screen?
|
| My display is set at 1024x768 and the form takes up most of the screen,
but
| I have some users whose display is 800x600 (for vision purposes) and they
can
| only see half the form when they run the program.
|
| I tried altering the Zoom property on the Userform but it cut off the text
| on some of the controls on the userform and I'm hoping that there's a way
to
| adjust everything at once.
|
| Thanks!
| Paul
|
|