There is no way to do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"javervoo" wrote in message
...
Is it possible to have a validation drop-down jump through the
list as a user
keys in text? For example, for a list of items: Apple, Bamboo,
Cat, and Dog
if the user keys C, it automatically jumps to Cat. We have a
drop-down with
about 1500 text values and it gets a bit tedious scrolling down
every time.
Thanks in advance.