VBA: To be enable to use down arrow key for selecting an item from search suggestion drop down list.

Zahid Marwat

New Member
Joined
Sep 19, 2015
Messages
31
I have a Combo Box on a UserForm named ComboBox1 with auto search suggestions i.e. if i type letter "a" it shows a list starting with letter a e.g. avocado, apple, almond, apricot etc.
If I use keyboard down arrow key to select one of the shortlisted items, it selects the first one item and then list disappears.
What I want is to be able to select one of the suggestions with the keyboard arrows keys by going up and down in the shortlisted items and hitting Enter.
I am using MS Excel 2013.
Thanking you all for support and help.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,223,958
Messages
6,175,635
Members
452,661
Latest member
Nonhle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top