ComboBox DropDown

[Mike1001]

Hi,

I have a combobox in a userform that I load with some data and I want the content of the combobox list to be displayed by using the ComboBox1.DropDown command.

The drop down list is actually shown, but while the form is shown in the center of the screen, the drop down list is shown in the upper left hand corner of it.

Is there any possibility to tell the drop down list to appear under the combobox?

Your help will be much appreciated!

Mike1001

[gfrantsen1961]

I'm not sure what you're asking.
If you are using a UserForm, you can position the controls any where you want to on that UserForm.
Could you attach your spreadsheet to your response so I could look at it?

[Mike1001]

Hi gfrantsen1961,

thanks for the reply. Below you can find the initializing Sub. As you can see, I am not specifying a certain position for the userform so that it appears in the middle of the screen (please ref to attached screen shot). The userform itself looks as desired, the first entry of the list is shown inside the ComboBox frame, but the remaining entries appear in the upper right hand corner. Of course, I could show the ComboBox itself on a different position on the screen, but how about the list that appears in the upper left hand corner which should appear directly below the ComboBox upon the .DropDown command? It works OK when I click on button with capture List (ref to code below for btnStart).

Can you help?

Thanks in advance!

Mike 1001

UserForm.jpg

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Mike1001]

In the meantime, I found the solution to my problem myself:
What you need to do to compensate different screen resolutions is to set the userform's startup position to 3 - Windows Default.