drop down lists

L

lizM

I created a drop down list with 8000+ entries. The list works fine but I am
unable to move through the list by typing a character ie. 'm' will take me
to all records starting with m. I ended up creating an entry form and the
list box work well on that but I still need to know where I went wrong
 
M

Mike Rogers

lizM

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, 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

T. Valko

If you used a Data Validation drop down list it doesn't have this ability.
One way to work around this if your list is sorted is to add an entry for
each letter like this:

A
Allen
Albert
B
Bob
Brian
C
Carol
Chris

Then you type in the first letter and click the drop arrow.

A combo box from the Control Toolbox has this ability.

Biff
 
Top