jana
asked on
The command '.DropDown' displays the contents way off it's combo box in Excel
We have a combobox that when is activate, we use 'ComboBox1.DropDown' to display the contents in a dropdown. However, the contents is always displayed way off the screen as to appear completely detached from the form and combobox (see pix below)
How can we make dropdown display wight under the combobox?
How can we make dropdown display wight under the combobox?
ASKER
Hi,
Just found the solution:
When creating a combo and we want to display contents as the "dropdown", we were using 'Me.cmbSheets.DropDown' in the wrong place.
After placing it 'UserForm_Activate()' worked fine.
Just found the solution:
Private Sub UserForm_Activate()
Me.cmbSheets.DropDown
End Sub
When creating a combo and we want to display contents as the "dropdown", we were using 'Me.cmbSheets.DropDown' in the wrong place.
After placing it 'UserForm_Activate()' worked fine.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for Ramante's comment #a41474906
for the following reason:
It solved the problem
Accepted answer: 0 points for Ramante's comment #a41474906
for the following reason:
It solved the problem
ASKER
Even though we solved the problem prior ID: 41474907, we will award the points to the EE since it is the solution.
Also, could you tell us which version of Excel you are using?