Could you email me the file. Thanks.


Robin Hammond
www.enhanceddatasystems.com


"keepITcool" wrote in message
...
Robin,

I did some further testing on your handler.
with a different set of items... (40320 permuts of "ABCDEFGH")


Your handler will not test on the existence of an item.
Rather it will generated an error and your handler will show
the generic messagebox "an error occured in the listhandler"

rather confusing..


Further in your handling code I found that your class appears to be
handling MultiSelect boxes...

And although multiselect is rather difficult to combine with typing,
I thought I'd give it a try... and set the "handled" box to
multiselectextended... which throws an error on each keypress.





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

Robin Hammond wrote in message
:

This one stemmed from frustration with trying to select items in a
list of several thousand alphabetically sorted items. Unlike the
Windows list handlers, Excel only reacts to a single key press.
Pressing "A" then "B" in quick succession will move you to the first
entry starting in "B", not to those starting "AB". So, rather than
write custom code for each list with lots of entries, I created a
class module that can be initialised for any list in a form. Multiple
class objects can also be created and assigned to multiple lists.
Usage is a doddle. All it needs is three lines of code.

The class is available for anyone who wants to try it out on my site
at the link below.
http://www.enhanceddatasystems.com/E...istHandler.htm

Please let me know if you find ways to improve on it.

Robin Hammond
www.enhanceddatasystems.com