Listbox MatchEntry Property

[John Keith]

MatchEntry help text (Office-Excel 2003):
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.

How do I make this property continually cycle through the first letter. The
_click event takes over when the last matching entry is highlited and I try
to cycle back to the top of the list (for the letter being typed)

Ideally, I'd like to be able to use the first letter keypress to select a
choice then with either a click or enter (then cause the _click event to
fire, which passes the selected item to the worksheet)

Also, once a keypress has selected(highlited) one of the choices, Clicking
that choice does not fire the _click event. If I can get the enter key press
to "choose" that item and run the code that will take the choice back to the
worksheet, this should be sufficient. [If the user uses the mouse for the
selection its not an issue. If the user uses the keyboard, then pressing
enter to "choose" should be sufficient too]

 

[Tom Ogilvy]

Read the help on MatchEntry. Once the characters are sufficient to match
only one choice, then the selection is made, same as if the user clicked on
that choice.

If you want diffent behavior than is supported by the selectable options,
then you will have to write the code to perform it.

As an example, you can set the listindex to -1 in the mousedown event if you
want to to be able to make a "fresh" selection on a selected item.