VBA Excel Sheet ComboBox issue

[dprayner]

Hi People.

I have about 100 ComboBoxes and I want to have a user select something from the list and also be able to bring up an entry from the alphabetized list by typing in the first letter of the entry. Each ComboBox is set with the following properties:

MatchEntry 0-fr Match Entry First Letter
MatchRequired True

If someone types a letter (i.e. O) and it is not on the list, the letter remains as the text in the ComboBox. I was wondering if there is another property I have to set to prevent this, or do I have to code for it in the Change() event.

Thank you, DAVE

 

[fumei]

I don't understand. You have it Match Entry First Letter, so if the user types in "O" and there are "O" entries, it will go there. Fine. Good. But if there ARE no "O" entires, yes the letter remains as text. Of course it would. The user typed in the field, and presumably the focus is still there. Could you explain exactly what you want TO happen? What does "prevent this" mean to you? The user typed in "O". Are you ask for something that parses user input, checks the existing list for First Letter, and then comes back with "Nah, what are you doing? There are no "O" entries"?

Gerry