Userform not displaying all the text

Pookiemeister

Board Regular
Joined
Nov 26, 2015
Messages
220
Office Version
2010
I was advised to post this question in this part of the forum. I noticed that some of the captions in the labels on the userform are not displaying all the text (its like there cut off). I'm assuming that has something to do with the screen resolution settings. Is there anyway to fix this issue, so the userform is displayed the same no matter what computer it is run on? This occasionally happens on my Excel userforms and Word userforms. Thank you.
 

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
5,345
Office Version
2013
Platform
Windows

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,395
It's not only screen resolution, the dpi (personalization) settings will also mess with your userform. You can trial this as it works for me.... UserForm not rendered correctly visually
Also, search this site for Jaafar as he has posted some code (probably better) on this same topic. HTH. Dave
 

CountTepes

Board Regular
Joined
Nov 8, 2010
Messages
90
Office Version
365, 2016
Platform
Windows
Following on from dmt32's answer.

I have also had this situation 10 years ago.

Instead of inserting a userform, I created it using VBA, having first obtained the screen resolution and DPI. Then adjust all your dimensions and font sizes as required.
 

Forum statistics

Threads
1,085,183
Messages
5,382,185
Members
401,779
Latest member
Thonor

Some videos you may like

This Week's Hot Topics

Top