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

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