I created a combobox to help the user to type the right name of a item that he's looking for. The combobox will suggest the possible values that the user can select, I did this combobox by using this guide (https://trumpexcel.com/excel-d…-with-search-suggestions/)
The only problem I found is the only way to select the value is by typping every letter or to click using the mouse in the dropdown list, but I want to allow the user to use the arrows keys to move through the list.
By using that combobox if the user use the arrow key it selects the first value in the dropdown list therefore removing all other matches
[ATTACH=JSON]{"data-align":"none","data-size":"full","title":"Exemple of the problem","data-attachmentid":1210446}[/ATTACH]
What I want is when using the arrow keys it wont select the value but scroll through the list until he founds what he needs.
I looked everywhere and found some people that had the same issues but none of them could help me, and thats why im here trying to found the answer.
Sample of the workbook attached to the topic