SELECTING FROM A DROP DOWN LIST BY TYPING FIRST CHARACTER

[MARGARET KISS]

I have a drop down list, and I type Z and clik on the arrow, it tells me that
its wrong.

I can use characters a-c but anything past that it does not accept it. What
I am trying to do is select from a list by typing the First Letter.

I tried searching in this community, but I could not find anything that
addresses my issue.

Any help, would be greatly appreciated.

 

[Gord Dibben]

Was the dropdown list created using Data>Validation>Allow>List?

What values are in the list? If Z is not on the list you will get the error.

Second point.................

There is no autocomplete function for DV lists.

You would have to use a combo-box dropdown to achieve autocomplete.

See Debta's site for more.

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


Gord Dibben MS Excel MVP

On Wed, 9 Jan 2008 09:10:02 -0800, MARGARET KISS <MARGARET

 

[David Biddulph]

Look at Data/ Validation.

 

[MARGARET KISS]

Thank you, I did use Data Validation and yes there is a Z in the drop down
list,

I will try your suggestion.