No, data validation works the way data validation works. It doesn't support
autocomplete.

--
Regards,
Tom Ogilvy

"Soniya" wrote in message
...
Hi all,

I have a datavalidation cell with list. Is it possible to
get the autocomplete function from the list using code or
built-in function?

TIA
Soniya