Adjust a Userforms Zoom based on screen resolution.

Hi all,

I have a userform that opens up to full screen regardless of the screen size. However the items populated within the userform are static. So if someone opens the userform on a small screen then they are missing visible information. I can add scroll bars but i'd much prefer all the information be visible upon opening the userform and not use scrolls bars. I figure that there must be a way to have an IF arguement that says if the screen resolution is a certain size then the userforms Zoom is a certain amount

Eg. I open the userform on my laptop at 1366 x 768 and the userform opens at 100 zoom but if a colleague opens it on their notebook which is 800 x 600 then the userform opens at 80 zoom.

The arguement would firstly need to find the screen resolution for the device opening the userform.

Can anyone help with this problem

Thanks in advance

Thanks Alf,

I'll try it out and see if it works. A quick question tho. Can I place both the declare function and the sub within the userform initialise?

I did come up with a simple work around for me that may be of use to a percentage of other excel amateurs. If your excel document is exclusive to a company server then you can use the if arguement for specific usernames.

Please Login or Register  to view this content.

All you'd need to know is the screen resolution of the computer that they log into and adjust the zoom size accordingly. Of course this is a work around only. It's not a solution because it doesn't help if the document isn't on a server, if there are 100's of users or if users are logging on to different computers using their usernames.