Drop-down updated on each keystroke
 

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

Drop-down updated on each keystroke
 

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

there is no built in capability to do this.

--
Regards,
Tom Ogilvy

"Alex" wrote in message
...
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