Hi,

I have a form that adds a name to a defined name list. This list i
already attached to a combo box. I have a few things I would like t
happen once this name has been entered. So, without further ado ;)
here are my questions:

1) Is there a way I can auto-configure the combo box to include the ne
record added to the bottom of the list?

2) To copy an existing worksheet and automatically replace word X wit
the new name added via the form.

3) To add the word from the form to all the defined name ranges in th
new worksheet.

If this is possible, it would be quite amazing :)

:confused

--
Message posted from http://www.ExcelForum.com