Custom Auto-Fill Question Similiar To Google

Quick question for you guys.

I have a bunch of repetitive data in one of my columns. Is there a way for excel to come up with a drop down menu or something similar when I type data into cells?

I'm aware of auto-fill but don't like it because it takes 1 or 2 words before auto complete can recognizes what i want to type in. I tried creating a custom list with auto-fill but it only displays a limited selection of the data that i want and kind of takes too long.

I want excel to offer me suggestion of all similar data when I type the first letter, and that way I can just scroll down and pick the appropriate value. Something like Google does when you typing a search.

So if you take a look at the excel sheet, when I type something for column 1, I want excel to present the possible selections existing in the above cells. I don't want it to repeat any values when picking a selection. I just want this appear somewhere so that I can easily pick it (Honestly, Personal, Img Below Add, Img No Bottom, Img Alien, Img Enhance, Img Personal, Locations)


Am I making any sense?

Can you guys point me in the right direction?

Thanks for the reply.

Can you tell me where to put this code?

Also, to learn more about this feature or rather what I want excel to do (combobox, active x?), what should I be looking for in my search for information? Active x box, combo box etc?

Something basic for a new excel user would be ideal.

Thanks

Been doing some reading on active x combo boxes and so on. I think I'm on the right track.

Still don't know where to put the code though?

Works great but I want this to do it for a selct columns - newsletters, from, date. subject and send group. How can I go about this?

Also is the only way to delete active x boxes through vba coding? There's no easier way to do this?

Appreciate the help,

thanks

Thank you for the help