pflosch
New Member
- Joined
- Sep 28, 2022
- Messages
- 14
- Office Version
- 2016
- Platform
- Windows
I could not find this in the forum so far, hope I didn't miss any.
I have 2 problems with the behaviour of my comboboxes, I link a Demo file to explain.
In the linked demo file,
Issue 1:
- if I type "a" in the box, I receive a choice in the dropdown and when I click on one, the click event fires.
- if I type "aa" in the box, the choice is only aa, and it's highlighted. If I click on it, no Click event is fired.
=>How do I know "aa" has been selected?
I would like to get anything I click on into the Combobox, regardless whether Excel thinks it's the favorite choice or not.
Issue 2:
- If I type "a" in the box and hit arrowDown key, it selects the first match.
=> How to have it just moving the selection highlight in the dropDown?
I would like to move with arrows and select with enter key... :/
I have 2 problems with the behaviour of my comboboxes, I link a Demo file to explain.
In the linked demo file,
Issue 1:
- if I type "a" in the box, I receive a choice in the dropdown and when I click on one, the click event fires.
- if I type "aa" in the box, the choice is only aa, and it's highlighted. If I click on it, no Click event is fired.
=>How do I know "aa" has been selected?
I would like to get anything I click on into the Combobox, regardless whether Excel thinks it's the favorite choice or not.
Issue 2:
- If I type "a" in the box and hit arrowDown key, it selects the first match.
=> How to have it just moving the selection highlight in the dropDown?
I would like to move with arrows and select with enter key... :/