Combo box Add To List
 

My combo boxes are part of the worksheet and are not on a user form. Each
one has properties set "do not print" and the value appears in the cell they
are linked to. Data for the combo boxes are stored in another workbook
called "Lists"
I would like to be able to add to the List workbook by typing a new value in
the combo box. At present I can type a new value in the combo box but it
is not added to the list workbook. As an added benefit it would be nice if
the user were ask if they would like to add the new value to the list.

--
Thank You