Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel cells randomly don't get updated unless each cell is updated | Excel Discussion (Misc queries) | |||
Tab Keystroke in Excel | Excel Discussion (Misc queries) | |||
Tab Keystroke in Excel | Excel Discussion (Misc queries) | |||
One keystroke per cell | Excel Discussion (Misc queries) | |||
Keystroke for Formatting | Excel Worksheet Functions |