Data Validation List

[Des_2001]

I want my validation cells, when I hit a certain key, to automatically go to
everything on my list that starts with that particular letter. For example,
if I hit 'B' and the first word that starts with 'B' on my list is 'bat,' I
want the word 'bat' to automatically pop up in the cell. Is there a way to do
this?

 

[L. Howard Kittle]

You can get close to that. Sort your validation list 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.

I believe there is an auto-complete using the drop down box from another
source in Excel, but it escapes me at the present. The above works for the
Data > Validation from the Forms tool bar.

HTH
Regards,
Howard

 

[Gord Dibben]

Use Howard's method or add a ComboBox which has autocomplete functionality.

See Debra Dalgleish's site for instructions and a sample workbook.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP