Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() ComboBox on a Userform. I am using the following code to display the dropdown list for a ComboBox when the user enters the ComboBox. However, when the form opens, the dropdown list for the first Combo box is towards the top left of the screen outside of the Userform instead of under the ComboBox control on the Userform. This occurs in both xl2002 and xl2007. If I reduce the size of the Excel window, the dropdown can be completely off the Excel window also. I can actually make a selection form the dropdown. It is almost like the drop down list is positioned relative to the top left of the screen instead of the userform. Any help to fix this problem will be greatly appreciated. Private Sub ComboBox1_Enter() If Me.ComboBox1.ListCount 0 Then Me.ComboBox1.DropDown End If End Sub -- Regards, OssieMac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combobox.DropDown not working | Excel Programming | |||
combobox dropdown | Excel Programming | |||
Disable and enable dropdown combobox(Form Control) | Excel Discussion (Misc queries) | |||
Dim CTL as MSForms.Control always sets as Control/Combobox | Excel Programming | |||
ComboBox DropDown when Key is pressed | Excel Programming |