Drop-Down List Detached From ComboBox - Excel VBA

Question

The drop down list of a ActiveX ComboBox detaches whenever I scroll down the page. How can I fix it so it won't move?

Here's the VBA code designated for the comboBox.

Private Sub ComboBox1_Change()

ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown

End Sub

As a note this behavior does exist as early as Excel 2003, so I suggest a tag modification. — ib11

ib11 ib11 · Accepted Answer · 2016-05-27T01:41:59

If you switch out your ComboBox to the one from the Forms toolbar, then it collapses the list as soon as you start scrolling. I think the "detaching" of the dropdown is the default behavior and I don't think you can influence that programmatically (as in here, too).

See this post on the different options for the comboboxes:

Run Macro When ComboBox is Clicked

Another option is to disable the mouse scroll, as in this post:

VBA Excel Combobox: drop-down list scrolling issue

Drop-Down List Detached From ComboBox - Excel VBA

1 Answers