You can have autocomplete in data validation if you use a combo box -
Debra Dalgleish shows how he

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

Hope this helps.

Pete

On Jan 27, 5:31*pm, funkymonty
wrote:
I am trying to create a drop down menu in Excel 2003.

I know how to do that...but I would like to make it so that when someone
enters starts to type something that exists in the list it automatically
jumps to that option.

AND/OR

Use the up and down arrow buttons to select the option in the dropdown list.

I have seen it done before so I know it can be done- but I just can not
figure out how!!

Thanks