Bexi

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

Gord Dibben  MS Excel MVP

Hi Bexi,

As Gord says, no auto-complete with Data > Validation.  However, this may do
what you want if you are able to sort your list.

Sort the list and then at the beginning of the A's enter a single A.  Do the
same for all the other letters on down the list, B, C etc.

Now when you want to select something from the list, type the letter in the
validation cell and DO NOT hit enter, the cell will still be in the edit
mode with the cursor blinking.  Click the drop down arrow and you will be at
that letters list.

You really can hit enter when you type in the letter but you will have to
reselect the cell which is another step.

HTH
Regards,
Howard

I tried it and it worked. THANK YOU.

But, I wanted to be able to just click the "Enter" key instead
of using the mouse every time I selected an item from the list.

Can I still add a VBA code that allows the user to use the "Enter" key
instead of using
the mouse? Do you have that code? I am an accoountant with a little
knowledge of programming.

Thank you once again.
Bexi