Quote Originally Posted by Rick Rothstein View Post
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?

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.
As you can imagine like the most of those that are dealing with vba I usually have multiple monitors, i.e. in my work laptop I have 1366x768 analysis while in the external monitor that I have plugged at work I have 1680x1050. At home I have a different monitor and the display is different (I can't tell you right now since I am at work, I will edit this post later to give you this info as well for your testing purposes...)

Also due to multiple displays I have added to the form the following code to make it appear in the display that excel is currently placed (actually I am using this code in all forms that I add ...)

Code:
Private Sub UserForm_Activate()
    
With Me
  .StartUpPosition = 0
  .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
  .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
End With
   
End Sub
I think that it would be handy to have this added in your code...

Finally I have used Tahoma 11 font in my userform listboxes and I have also changed your listboxes to this setting in order to have a consistency....
Closing (although not necessary), thanks for your permission....