drop down lists

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Position of a drop-down list 5
drop-down listbox disappeared 2
Filtered drop down list 2
Drop Down List Location Question 3
drop down list populating 2
Size of drop down in validation list 2
Formatting a drop down list 2
drop down list based on other drop down list pick 1

Back
Top