graphical user form design unexpectedly resizes for no reason (!!?)

[6diegodiego9]

I have a dual screen with different resolutions and often my userform size gets unwantedly resized for absolutely no apparent reason (surely I don't change any property or code at all when it happens)

This:

suddenly and unexpectedly becomes this:

How can I prevent this to happen?

 

[Kenneth Hobson]

Make the display settings the same on both monitors.

 

[6diegodiego9]

Make the display settings the same on both monitors.

I understand that this could be a workaround but they're two completely different monitors: one is my laptop integrated monitor, the other is a big external monitor with a higher resolution. As you can understand, it's not acceptable to me to lower the resolution on the bigger monitor just to make the user form stay stable.
What makes me crazy is that the user form appearance (graphic and font sizes) doesn't stay stable even on the same monitor

 

[Kenneth Hobson]

The first thing to try would be the first Option. The last 2 likely won't help much.

1. File > Options >General section > Optimize for Compatibility
2. File > Options > Advanced > Display section > Disable Hardware Graphics Acceleration
4. Start > type Ease of Access Magnifier Settings > select it and adjust the setting.

 

[6diegodiego9]

Kenneth, I forgot to mention that there are about ten different users with different PC/screens who will use my VBA script with the user form.
Is it generally accepted that VBA user forms will show differently (and badly deformed too, not just zoomed) depending on the user screen settings?

 

[Kenneth Hobson]

I have not seen it but some links looking at your problem showed that to be the case.

I would try (1) for yourself and then recommend it to others if that have issues.

 

[Kyle123]

It'll be the scaling of the screen rather than the resolution. I suspect that if they're both at 100% you won't have the issue, it's becoming more of an issue where people have hi-dpi laptop screens and regular dpi monitors (you can of course have both, but externally scaled monitors are less common as hi-dpi monitors are expensive).

The key giveaway here is that the screenshot from one of your devices is 2x the size of the other.

Do you perchance have a better laptop than most of the people who will be using the workbook? If so, this may not be an issue. This is a common problem in windows, it doesn't deal with differing zoom settings on different monitors well, especially when using older software that's bitmap based.

 

[6diegodiego9]

I have not seen it but some links looking at your problem showed that to be the case.

I would try (1) for yourself and then recommend it to others if that have issues.

I'm trying this now and I'm still not sure about the results because I didn't find a certain way to reproduce the problem.
However, the users are not IT experts and they don't know me personally, so I can't expect them to ask me for help and to modify this setting just to adjust a graphical issue of my little script

 

[6diegodiego9]

It'll be the scaling of the screen rather than the resolution. I suspect that if they're both at 100% you won't have the issue, it's becoming more of an issue where people have hi-dpi laptop screens and regular dpi monitors (you can of course have both, but externally scaled monitors are less common as hi-dpi monitors are expensive).

The key giveaway here is that the screenshot from one of your devices is 2x the size of the other.

Do you perchance have a better laptop than most of the people who will be using the workbook? If so, this may not be an issue. This is a common problem in windows, it doesn't deal with differing zoom settings on different monitors well, especially when using older software that's bitmap based.

It could be the scaling but I would expect the visualization differences to just happen on the execution level, while they seem to applied on the code as well instead, de facto corrupting it. I'm confused...

 

[NdNoviceHlp]

Both screen resolution and dpi settings will affect the userform size across pc's. Here's a link to some code. HTH. Dave

Userform size displays incorrectly

Hi, I have created a tool for many users in my company. The interface is built around a main userform. I am having an issue with only one user where the userform seems to be so zoomed in on her screen that she is not able to access all of the content. I check her resolution and it is the same...

www.mrexcel.com