Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation 'Jump To'
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Ash Chip said, Data Validation dropdown lists don't support
autocomplete. If you can use programming, there are instructions here for adding a combobox from which you can select one of the values from the data validation list. In the combobox, you can enable autocomplete: http://www.contextures.com/xlDataVal11.html javervoo wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you jump to a selection in a validation drop-down? | Excel Worksheet Functions | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |