can you scroll through list box when words start with same letter

Z

Zman23

For example; I have a list box that has Mr., Mrs., Ms., and Miss in it. When
entering data I want to be able to hit "m" and have it go to Mr. (Which it
does). What I can't get it to do is when I hit "m" twice (mm) have it go to
Mrs. When I hit "m" 3 times (mmm) have it go to Ms. and so on. Please help
me. Thanks!
 
J

John Vinson

For example; I have a list box that has Mr., Mrs., Ms., and Miss in it. When
entering data I want to be able to hit "m" and have it go to Mr. (Which it
does). What I can't get it to do is when I hit "m" twice (mm) have it go to
Mrs. When I hit "m" 3 times (mmm) have it go to Ms. and so on. Please help
me. Thanks!

Consider using a Combo Box instead of a listbox. When you type M it
will go to Mr.; when you type I (after having typed M) it will jump
directly to Miss.

That way you can't miss!

John W. Vinson[MVP]
 
Top