SELECTING FROM A DROP DOWN LIST BY TYPING FIRST CHARACTER

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MARGARET KISS - 09 Jan 2008 17:10 GMT

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.

Reply to this Message

Gord Dibben - 09 Jan 2008 18:08 GMT

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

>I have a drop down list, and I type Z and clik on the arrow, it tells me that
>its wrong.
[quoted text clipped - 6 lines]
>
>Any help, would be greatly appreciated.

Reply to this Message

MARGARET KISS - 09 Jan 2008 20:53 GMT

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

I will try your suggestion.

> Was the dropdown list created using Data>Validation>Allow>List?
>
[quoted text clipped - 22 lines]
> >
> >Any help, would be greatly appreciated.

Reply to this Message

David Biddulph - 09 Jan 2008 18:21 GMT

Look at Data/ Validation.

Signature

David Biddulph

>I have a drop down list, and I type Z and clik on the arrow, it tells me
>that
[quoted text clipped - 8 lines]
>
> Any help, would be greatly appreciated.

Reply to this Message