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)
![combobox way off]()
How can we make dropdown display wight under the combobox?
How can we make dropdown display wight under the combobox?
Microsoft Excel
Last Comment
jana
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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?