Drop down box and lists

You can't enable autocomplete in a cell, I've done it with VBA using TextBoxes but unless you absolutely must do this my conclusion in the end was that it absolutely was not worth the effort to write the code and set everything up to make it work.