See if links help

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

http://www.contextures.com/xlDataVal10.html

VBA Noob