Take a look at Debra Dalgleish's site here:

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

she shows how to use a combo box which has the AutoComplete feature.

Hope this helps.

Pete