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

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


--
The only dumb question is the one you did not ask.


"maperalia" wrote:

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

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

--
Biff
Microsoft Excel MVP


"maperalia" wrote in message
...
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

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

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


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 01:50:56 -0400, "T. Valko" wrote:

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

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

--
Biff
Microsoft Excel MVP


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Debra Dalgleish shows how to implement Biff's solution at her site.

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


Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 01:50:56 -0400, "T. Valko"
wrote:

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