Hi Excel expert,

I want to have a pull-down menu which contains all the values that I want to
insert into a cell in the spreadsheet so I can easily select and insert that
value into a selected cell.
Currently, I use the data validation feature of excel to create this
pull-down menu. However, it does not allow me to enter new values which are
not on the list.

Is there anyway to create this kind of value list but not only allow the
user to select the desire value from the list but also enter a new value.

Thank you,
Andy Bui