Userforms and Laptop Screen Resolution

[RawlinsCross]

Good day,

I design VBA applications that are very userform-centric. I make them on my laptop which has a higher-resolution (HD) screen. When end-users run the application on "lower-end" laptops that do not have higher-resolution screens the userforms are not rendered correctly and appear all blown-out of proportion. To-date, I've asked those users to dock their laptops and use monitors that are high-def and that fixes the problem. Do I have any avenues to address this problem if end-users want to use their low-resolution screen laptops alone?

 

[dmt32]

One idea, create two userforms - one for HD screen the other for lower resolution & then get your code to detect which form to display.

Dave

 

[RawlinsCross]

Hey Dave... yeah, these applications can involve 10 or more userforms and are complex userforms - seems a bit much to design everything in duplicate. Is that my only option you think? Maybe I'll wait till everyone upgrades.. hahaha.

 

[mikerickson]

If the problem is control location, you can write Activate events to tidy things.
If the problem is readablity of text, use a bigger font. If screen resolution makes the text hard to read, the desired font size is too small, particularly for users with older eyes, even if they have higher resolution screens.

 

[dmt32]

Hey Dave... yeah, these applications can involve 10 or more userforms and are complex userforms - seems a bit much to design everything in duplicate. Is that my only option you think? Maybe I'll wait till everyone upgrades.. hahaha.

Not your only option but maybe a simple fix for couple of forms- you only need to duplicate the form and adjust for required resolution - all the codes can be placed in a standard module for the forms to access.

Dave

 

[dmt32]

Took me awhile but found link that may be of help to your project

autosizing userform display

I have a userform where I need to have the entire form visible on screen of any computer excel runs on. The size of both the form and the various controls/text in the userform need to be resized. This is something that I of course never considered as an issue, thinking excel would do this...

www.mrexcel.com

#Post 6 - @Jaafar Tribak created a nice autosizing solution which Hopefully will be of some help.

Dave

 

[RawlinsCross]

Thanks Dave... will check it out!