If your drop-down list if from Data Validation, you cannot have Autocomplete.

Try a combo-box drop-down list.

Debra Dalgleish has instructions.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Mon, 14 Aug 2006 17:14:49 -0400, chris100
wrote:


Hi all,

Not sure if this is a question for here or programming....

Anyone know how in a pull down list when you type the first letter (e.g
S) it will jump to the the first entry in the list with S and then if
you type E, it would jump to the first entry starting with SE?????

Thanks a bundle,

Chris