Hi,

Here is a site that uses a non-vba approach for that:

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"mike c" wrote:

I have a list of over 100 items in my drop down (data validation list) I am
looking for a solution to allow me to type in the first 2 or 3 letters of the
word so I can narrow my search. Does anyone have a suggestion of how to
accomplish this.

Thanks
mike