Forum Discussion

Anggie's avatar
Anggie
Copper Contributor
Sep 04, 2019

VBA Drop Down List

Hi Everyone, I developed a combo box drop down list and added a code that works fine but doesn’t let me scroll down my listed options using my down arrow keyboard button. Is there a code to use the d...
excel
Formulas and Functions
Macros and VBA
Anggie's avatar
Anggie
Copper Contributor
Sep 10, 2019
The code you sent me runs smoothly. Now I want to know which element in my combo box has the focus. And how can I change that selection or move that focus to another element.
Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Sep 10, 2019

Anggie 

Now place this code...

Private Sub ComboBox1_Change()
Me.ComboBox1.DropDown
End Sub

And use UP and Down arrow keys to scroll up and down and hit Enter to select an item.

  • AC22J's avatar
    AC22J
    Copper Contributor
    Jul 11, 2022
    Subodh_Tiwari_sktneer
    Excel gives "Compile error: Invalid use of Me keyword" on this code:

    Private Sub ComboBox1_Change()
    Me.ComboBox1.DropDown
    End Sub

Resources