Autofill/Autocomplete Prediction PullDown Lists

C

chris100

Hi all,

Not sure if this is a question for here or programming....

Anyone know how in a pull down list when you type the first letter (e.
S) it will jump to the the first entry in the list with S and then i
you type E, it would jump to the first entry starting with SE?????

Thanks a bundle,

Chri
 
C

chris100

Thanks for the help Gord.

i finally got round to trying this one out and it works great. The
only thing is i'd like to limit the amount of mouse use by the user and
hopefully make things a little quicker.

Could you help me change the code where say pressing the shift key
activates the procedure?

As always thanks to all you helpful people...
 
C

chris100

Sorry to bring this back up to the top but i think it's better than
creating a new post.

Does anyone have an idea to replace the doubleclick with something like
pressing the shift key twice or "shift+\". I'm not that good with VBA
but i figured this would make an already good piece of script be even
more user friendly....i hope.

Regards,

Chris
 
Top