Thread: DATA VALIDATION
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default DATA VALIDATION

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?