Is it reasonable, or possible, to try to set a userform to size it with a different screen resolution?
We have a few systems that are set to a screen resolution of 800 x 600 and I usualy try to set to that resolution for any userforms or setting individual sheet zoom resolution.
For individual sheet resolution I frequently use something like:
However, this does nothing for the userform. If a user opens the workbook with a screen resolution of 1024 x 768 or even greater the userform starts to look rather small.
Is there a way to detect what the screen resolution might be, set som constants accordingly and change the individual sheet zoom as well as the userform sizing?
If so, where can I find examples?
Bookmarks