get to a particular point in a dropdown list

[Prema]

I have datavalidation set up in a cell to pick up from a long list. Is there
anything I can do so that as I type in that particular cell it moves down the
list for selection?

i.e. if I type B it will got to the point of the list near B and when I type
the next character E it will go near BE in the list?

Thank you

[Ardus Petus]

You nedd a ListBox to have that functionality.

HTH
--
AP

"Prema" <[email protected]> a écrit dans le message de news:
[email protected]...
>I have datavalidation set up in a cell to pick up from a long list. Is
>there
> anything I can do so that as I type in that particular cell it moves down
> the
> list for selection?
>
> i.e. if I type B it will got to the point of the list near B and when I
> type
> the next character E it will go near BE in the list?
>
> Thank you