Young Grasshopper
Board Regular
- Joined
- Dec 9, 2022
- Messages
- 58
- Office Version
- 365
- 2016
- Platform
- Windows
Hello World,
I have this userform that implements a lot of images for design, buttens, animations etc.
Usually i connect my laptop to duel monitors that implements 100% display scaling, and i designed the whole thing in there. But quickly enough i learned that if i open excel and the userform when i just use the laptop display, that is usually in 125% display scaling, everything shifted.
This is of course because of the diffrent resolutions or whatever, and that's fine. My original plan was just to implement a code to get the users display resolution, then make two diffrent forms and load the right one.
But then i noticed that if i change my display scaling to 100% and open the workbook, then change the scaling back to 125% the text size and everything goes back to "normal", but the forms also load and is displayed correctly! Why is that?
It seems wierd to me that if you can "trick" the system that easy, the software should just scale userform and images to look the same everytime. Is there a way to use this anyway when loading forms, or is this just a happy side effect that I don't understand?
Not really looking for a solution, more an enlightenment of why this can be done
I have this userform that implements a lot of images for design, buttens, animations etc.
Usually i connect my laptop to duel monitors that implements 100% display scaling, and i designed the whole thing in there. But quickly enough i learned that if i open excel and the userform when i just use the laptop display, that is usually in 125% display scaling, everything shifted.
This is of course because of the diffrent resolutions or whatever, and that's fine. My original plan was just to implement a code to get the users display resolution, then make two diffrent forms and load the right one.
But then i noticed that if i change my display scaling to 100% and open the workbook, then change the scaling back to 125% the text size and everything goes back to "normal", but the forms also load and is displayed correctly! Why is that?
It seems wierd to me that if you can "trick" the system that easy, the software should just scale userform and images to look the same everytime. Is there a way to use this anyway when loading forms, or is this just a happy side effect that I don't understand?
Not really looking for a solution, more an enlightenment of why this can be done