Hi,

I am designing a system that I want to look like it is not an Excel
spreadsheet. I would therefore like the UserForms to fill the screen. I can
do this manually but if somebody else has a different screen resolution it
doesn't fit right.

Is there a way of doing this automatically?
Can you use an if to determine screen resolution?

Thanks in advance for any help you can offer.
JohnP