In a userform, the listbox or combox can be set to jump to the closest match
as you type - it doesn't reduce the possible selections, but this should
achieve the desired result. You would need to sort the list.
It really doesn't require code. You just use the MatchEntry property:
Here are the choices (from help)
fmMatchEntryFirstLetter
Value: 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
Value: 1
Extended matching. As each character is typed, the control searches for an
entry matching all characters entered (default).
FmMatchEntryNone
Value: 2
No matching.
You need to read the vba help on this to get further information. Look at
some of the other properties of the listbox or combobox as well.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
