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