Data Validation-List..Question?

[Guest]

I have created a data validation -list where my source has 3000 names.
The problem is that everytime I dropdrown to see the list I have to scroll
the bar until I find the name I am looking for.

I wonder if there is away to type the first letter and the list will show me
just the names with the first letter instead.

Thanks in advance.
Maperalia

 

[Guest]

maperalia

In xl2k you can sort your list "ascending" and at each change in the first
letter of your list, insert a cell and place the appropriate letter. In your
dropdown cell first just enter the first letter and then click the dropdown
arrow and you are at the beginning of that part of your list.

Does that help?

Mike Rogers

 

[T. Valko]

An alternative is to use a combo box from the control toolbox. This has a
MatchEntry property which will match the first letter typed.

 

[Gord Dibben]

Debra Dalgleish shows how to implement Biff's solution at her site.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

 

[T. Valko]

I was suggesting to use the combo box instead of the data validation drop
down but either will work.