I'm enhancing a project that utilizes a Data Validation dropdown box in one column. It works fine but the users have gotten spoiled by the comboboxes that I included on a userform that allow them to jump down to a list entry by typing the name.

Is there any relatively simple way to do this on a sheet itself? I know I can add a combobox control to the sheet but what I need is one that would active on each cell in a particular column. I'm thinking it would be possible to do something along the lines of having a combobox that moves down to the active cell, allowing the user to select a value and then inserts said value in the active cell. Is this possible? If so, what would be the best way to go about it?