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