Autocomplete in list validation

[huutri]

Hi all

I am building sheet template in excel. I have big problem: I want to use autocomplete in list validation but excel 2007 is not support this function. Anybody has experencies about my problem, Please share it to me. Thanks

 

[grizz]

this may help
http://www.ozgrid.com/Excel/autocomplete-validation.htm

 

[huutri]

Thank for your reply
I saw link that you send to me. But it really is not support autocomplete in list validation in excel. can everybody help me to resolve this problem?

 

[grizz]

that is the only way to auto complete in data validation
Data validation does not support auto complete