ExcelBanter - AutoComplete in a List

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - AutoComplete in a List (https://www.excelbanter.com/excel-programming/280654-autocomplete-list.html)

Soniya[_2_]

AutoComplete in a List

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

Tom Ogilvy

AutoComplete in a List

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

All times are GMT +1. The time now is 09:07 AM.