I am using an ActiveX Control Combo Box that references a list in the sheet. Autocomplete is enabled and working well. The issue I am having is that when I start typing the first few letters of the item on the list, I see the rest of the item description from the autocomplete but I cannot hit enter to finish populating the Combo Box with the remaining untyped letters.
For example (my list is names)
I type in “Joh” and the autocomplete displays “John Doe.” So I can see autocomplete is working properly, but when I see “John Doe” after just type the first 3 letters (“Joh) I can’t hit enter to accept the autocomplete selection.
I would like to be able to hit enter and the entire name be populated in the Combo Box.