how auto complete text in Excel work?

[Flicker]

Hello, I want to prepare a sheet that user will enter a name of country. However, to prevent user enter nonexistence country, I use data validation - list type. However, user complain that this is not user friendly because she has to select country name from a very long list or type full country name. so, I'm thinking about sometime Excel can auto complete a text that I had been entered recently automatically. i.e. I enter Afghanistan once. The next time I type A, Excel auto complete with Afghanistan. I do not know how to add list of country to the list of auto complete that Excel might use. Any suggestion please?

 

[VoG]

Here is one way http://www.contextures.com/xlDataVal14.html

 

[Flicker]

Thank you very much, VoG after I post the topic, I found this link as well. http://www.ozgrid.com/Excel/autocomplete-validation.htm I'm also peek the link you given as well. It look like a combo box rather than data validation. So, it's mean the advantage of combo box is it can type :D. Thank you very much again.

 

[mgm05267]

Hil Flicker,

I got your point. You mean to say that if A is entered, excel should autocomplete the name

This is possible only when there are names entered already in that column range.

Try keeping all the names above the range in same column you want to enter and hide it.

OR go for VBA code as suggested by VoG

Regards,

MGM