O
OssieMac
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
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