MatchEntry property
Returns or sets a value indicating how a ListBox or ComboBox searches its list as the user types.
Syntax
object.MatchEntry [= fmMatchEntry ]
The MatchEntry property syntax has these parts:
Part | Description |
---|---|
object | Required. A valid object. |
fmMatchEntry | Optional. The rule used to match entries in the list. |
Settings
The settings for fmMatchEntry are:
Constant | Value | Description |
---|---|---|
fmMatchEntryFirstLetter | 0 | Basic matching. The control searches for the next entry that starts with the character entered. Repeatedly typing the same letter cycles through all entries beginning with that letter. |
FmMatchEntryComplete | 1 | Extended matching. As each character is typed, the control searches for an entry matching all characters entered (default). |
FmMatchEntryNone | 2 | No matching. |
Remarks
The MatchEntry property searches entries from the TextColumn property of a ListBox or ComboBox.
The control searches the column identified by TextColumn for an entry that matches the user's typed entry. Upon finding a match, the row containing the match is selected, the contents of the column are displayed, and the contents of its BoundColumn property become the value of the control. If the match is unambiguous, finding the match initiates the Click event.
The control initiates the Click event as soon as the user types a sequence of characters that match exactly one entry in the list. As the user types, the entry is compared with the current row in the list and with the next row in the list. When the entry matches only the current row, the match is unambiguous.
In Microsoft Forms, this is true regardless of whether the list is sorted. This means that the control finds the first occurrence that matches the entry, based on the order of items in the list.
Note that in either case, the matched entry is not unique; however, it is sufficiently different from the adjacent entry that the control interprets the match as unambiguous and initiates the Click event.
See also
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.
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기