Hmm, you raise an interesting point. I have kept my monitors set to a height of 768 pixel (over the years the width has varied from 1024 to 1366 pixels) because that makes the screen more readable to me given my eyesight, but I'm guessing you, like probably the vast majority of people, use the higher resolutions available on their monitors. That, in turn, affects the display size of the UserForm I designed (more pixels means smaller pixels which means physically smaller UserForms). I might look into modifying the code in my "Go To Sheet" selector UserForm so it dynamically sizes the UserForm to the monitor's display setting. To help me in trying to do that, could you tell me what display size your monitor is set at (you should be able to get that from Windows Control Panel via its Display applet)? Also, what font size did you use for the UserForm you used in your UserForm?Originally Posted by MrBlackd
Now that I think about it the only better thing in my replication is that I have made the font a little bit bigger to see ...lol
Of course I do not mind... anything I post in my sub-Forum, or in answers to any online questions (whether in this Forum or others that I volunteer at), is done so with the hope that readers may find a use for them in their own work.
Reply With Quote
Bookmarks