Data Validation-List..Question?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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.
 
Back
Top