Link to home
Start Free TrialLog in
Avatar of jana
janaFlag for United States of America

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)

User generated image
How can we make dropdown display wight under the combobox?
Avatar of byundt
byundt
Flag of United States of America image

Could you please post a sample file that reproduces the problem?

Also, could you tell us which version of Excel you are using?
Avatar of jana

ASKER

Hi,

Just found the solution:

Private Sub UserForm_Activate()
Me.cmbSheets.DropDown
End Sub

Open in new window


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
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

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
Avatar of jana

ASKER

Even though we solved the problem prior ID: 41474907, we will award the points to the EE since it is the solution.