LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default Listbox MatchEntry Property

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]

--
Regards,
John
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add custom property to a listbox? mkweaver Excel Programming 0 March 25th 06 10:56 PM
list property of listbox x taol Excel Programming 3 January 20th 06 07:50 PM
MatchEntry for combobox added during runtime Claus[_3_] Excel Programming 6 October 13th 05 12:43 PM
Runtime error 380: Could not set the List property. invalid property value of listbox jasgrand Excel Programming 0 October 6th 04 09:28 PM
ListBox.ColumnHeads Property Kevin Excel Programming 4 July 16th 04 10:55 AM


All times are GMT +1. The time now is 06:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"