You nedd a ListBox to have that functionality.

HTH
--
AP

"Prema" a écrit dans le message de news:
...
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