ExcelBanter - Sizing a UserForm

--
Richard

"Doug Glancy" wrote:

I'm glad it worked for you.

Doug Glancy

"darryl26" wrote in message
...
Wow! Works great!

Thanks

"darryl26" wrote:

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