You can thank me for pointing you to Debra's site, she's actually the one
that made you look brilliant this time. Glad I could help.

"el zorro" wrote:

Awesome, you made me looked like I'm an expert. Thanks much.

"JLatham" wrote:

No. and Yes. Regular data validation does not provide
auto-select/auto-complete. But one solution to the issue has been provided
by Debra Dalgliesh at contextures.com:
http://www.contextures.com/xlDataVal10.html



"el zorro" wrote:

DATA VALIDATION - LIST - SOURCE; the entries on my "source" name is so long
that I would like it to automatically go to the first selection when I type
the first letter of what I'm looking for. Is this at all possible?