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?
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?