Drop-down updated on each keystroke

[Guest]

Is there a way to automatically filter the drop-down list of data-validation
after each keystroke?

For example, there is a list in Sheet1 containing all the possible entries
for data validation. This list would contain:

A
1 Apple
2 Cabbage
3 Cucomber

When a user presses a key in a data-validated cell (which will be in
Sheet2), the list would automatically update to show only the matching
entries in it (like the Internet Explorer Auto-Complete feature).

For example, when a user first selects a blank cell, all the possible
entries would be listed. Then, when the user types "C", only "Cabbage" and
"Cucomber" would be listed. When the user types "Cu", only the "Cucomber"
entry would be available, and if possible, automatically selected. The reason
I'm asking this is the real list has over 500 entries and it is way too long
to scroll down to find the correct one.

Is there a way to do this using only data-validation? I've also been trying
to do it using a macro but I can't seem to figure it out...

Thanks for your help,

Alex

 

[Tom Ogilvy]

the user is editing the cell at this point, macros won't run

there is no built in capability to do this.