If you use a ComboBox on a Userform you don't have to use only the names that drop down. You can type in a completely new word/name. You will need VBA code to handle what values show up in the combobox.

I'd suggest looking at the RowSource of you combobox data being a named range. Perhaps even a dynamic named range where you keep your ever-changing list.

See http://www.vertex42.com/ExcelArticle...ed-ranges.html

hope this helps.