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



"lizM" wrote:

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