Here is the best solution - using a combo box (Again, from contextures http://www.contextures.com/xlDataVal14.html ). This approach puts a combo box (properties can be changed to suit) in any selected DV cell, and with additional code at the bottom, will dismiss the combo box when the next cell is selected. Remember to change the combobox name in the code.