Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel-VBA-ComboBox List display problem

Status
Not open for further replies.

Firery

Technical User
Sep 23, 2003
18
AU
Greeting,
Excel 2003, Workbook with a form. The form has a ComboBox which is populated during the UserForm_Initialize. The Combobox 'Style' is set to 2 - DropDownList.
The last line in the initialize is to DropDown the list in the combobox for the user to view when the form appears, (ComboBox1.DropDown)

Problem = The DropDown list appears on the screen completely detached from the form and the combobox. The list is near the top left corner of the screen, whereas the form is centre screen.

I have tried 'Repaint', setting focus to another control before the DropDown line, no good.

Any Ideas?
 
Put the .dropdown code in the Userform_Activate() event instead of _initialize(). Don't know why it works though.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top