[HELP]Auto Complete Text from the List

Hi there,

I am a beginner of Macro/VBA or actually I am just using
codes from our experts and applied it in actual. Also this
is my first post in this forum. Please help me out.

I've been using Data Validation-List.
I just want to know if you can make my work easy.
What I want is that if I am going to type in the cell, it will
automatically recommend answer coming from the list.

Thank You Very Much.

By the Way I hope to you can make it to MS excel 97-2003 workbook.

Thank You sir. I will test if.
for more feedback. Thank You again

Hi there, I have found tutorial about this, it is called combo box.
It is good but, it is uneasy for me as an encoder because I have to
double click first the cell before the combo box appears.

It there other way to get rid of the double click?