Hi all

I have cells containing large drop down lists (offering many possible entries). Is it possible to get excel to "jump" in the list or complete the entry automatically? If i start typing "aut", it should the drop down entry "automation". For your information, I just use Define Name and Data Validation to create the drop down list. Can anybody expert here to tell me how to do it? Is it must be using VBA code or I just can use Define Name and Data Validation which has been I created?

Thanks you!

Regard
st3vi3