letter recognition in drop down lists

H

henben

How do I get first letter recognition in a drop-down list without having to
use combo boxes?

I have about 500 rows, and on each row a selection has to be made in a cell
from a drop down list. Instead of having to scroll through the list, i would
like to type in the first few letters of the data item and the list to
recognise which item i'm trying to get...

help please!
 
L

L. Howard Kittle

You can get close to that. Sort your validation lists and at the beginning
of the A's enter a single A, do the same for the beginning of the B's and
all the way through to the Z's.

Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.

Should take you to the O which is the top of the O list of selections.

HTH
Regards,
Howard
 

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

Linking drop down lists to another list 4
Drop-Down List 3
Conditional drop down list 3
drop down list 1
drop down list populating 2
Cascading Drop-Down Lists 4
Drop Down Lists 2
Drop Down Lists 2

Top