Auto complete for data validation list

[KevinThomas]

I use a dynamic range list for my data validation list (code as below)

Please Login or Register  to view this content.

The problem is, there are sometimes up too 800 different selections, I’m trying and struggling to understand if it is possible to use some form of “auto complete” function, so if I started typing Fre… for example it would jump to Fre in the list rather than having to scroll through teh options.

I’m using excel 2007 by the way

[DonkeyOte]

No Auto Complete with DV by default I'm afraid.

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