| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for a specific entry in a long data validation list
I have a long data validation list and want to know is there a way of doing a
search on the drop down list, without scrolling down the list to the entry you are looking for. In some programmes if you do a search it display the possibilities as you type eg a - possibilities starting with a; ad - all possibilties starting with ad etc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search for a specific entry in a long data validation list
Not using a DV dropdown.
Have you thought about using a Combobox instead? With this method you have "Autocomplete" and resizing to show more items and you can change the font size. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Fri, 4 May 2007 06:11:00 -0700, Heinrich wrote: I have a long data validation list and want to know is there a way of doing a search on the drop down list, without scrolling down the list to the entry you are looking for. In some programmes if you do a search it display the possibilities as you type eg a - possibilities starting with a; ad - all possibilties starting with ad etc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula too Long for List Validation | Excel Discussion (Misc queries) | |||
| Validation list that also allows user entry? | Excel Worksheet Functions | |||
| Use Validation to force specific entry of first 3 characters in st | Excel Worksheet Functions | |||
| searching a large database with a long list of search terms | Excel Discussion (Misc queries) | |||
| Adding entry to validation list without retyping all lists | Excel Discussion (Misc queries) | |||
Linear Mode
