Match Entries in a List to Entries Typed by Users
In the Form Designer, drag the ListBox or ComboBox control from the Control Toolbox to the form.
Right-click the list box or combo box, and then click Advanced Properties.
To set the MatchEntry property, click the property, specify a value in the Properties box, and then click Apply.
For more information about the property for the specific control, see the following:
- MatchEntry property for the ListBox control.
- MatchEntry property for the ComboBox control.
**Set this MatchEntry value ** | To |
---|---|
No matching | Provide no matching. |
First letter | Compare the most recently typed letter to the first letter of each entry in the list (the first match in the list is selected). |
Complete | Compare the user's entry and an exact match in an entry from the list. |
Note
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for