What determines the size of the userform other than screen resolution?

[mobucl]

Hi all,

Reading information from various places i understand that the size of the userform is usually determined by the screen resolution of the monitor. However in an application i am developing i have witnessed the userform appearing oversized on another computer which has exactly the same resolution setting as the one i am developing on.

This has leads to the question as to why? What is being used to determine the useform size if it is not resolution?

thanks

Matt

[Aflatoon]

Probably the dpi setting?

[mobucl]

Ok thanks - is the DPI setting usually used by excel to determine userform size rather than resolution? How can i get this information feed into VBA. I can then use one of the autosize functions thats out there to change the useform size.

Thanks

Matt

[Aflatoon]

You can use API calls like this: https://www.pcreview.co.uk/threads/how-to-determine-the-dpi-setting-for-current-user.2521177/

[mobucl]

Great thanks Aflatoon, i will give this a go!