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.
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.