add new value to named range

[wpryan]

Hi All,
I have a named range that I want to be able to grow with newly added items. For example: we have a customer list in an in-cell drop down that is referenced in a named range. I would like to be able to select an existing customer or add a new customer, if the customer doesn't exist. Is there a way to do this in VBA? Thanks in advance.

[NBVC]

See here for a suggestion:

http://www.ozgrid.com/Excel/excel-va...ist-update.htm

[wpryan]

Thanks for your reply. I tried this, and it works only if the named range is in the same worksheet as the drop-down box. I need the range to be in another worksheet, therefore I suppose I need to declare the range as being in the other worksheet. I'm afraid I don't know how to do that. ...care to help?

[NBVC]

Try:

Please Login or Register  to view this content.

Replace the sheetname, Sheet2 with the sheet that has the list.

Also, replace $A$1 in Target.Address = "$A$1" with the cell containing the dropdown list.

[wpryan]

That's fantastic, thanks!