Update Validation List from cell

Is there any VBA way that when a user enters an invalid name into a cell with
validation that they can be prompted to add the new name to the list?

Put the message to the user in the Error message box found on the
Validation Dialog Error Alert tab.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"pkeegs" <[email protected]> wrote in message
news:[email protected]...
> Is there any VBA way that when a user enters an invalid name
> into a cell with
> validation that they can be prompted to add the new name to the
> list?

Thanks Chip, but not quite what I was after. When the Error message comes up,
can I construct the message box to include "Do you want to add another item
to the list" with vbOK taking you to a Macro which will add, or vbNo
cancelling out of the message box.

Cheers

"Chip Pearson" wrote:

> Put the message to the user in the Error message box found on the
> Validation Dialog Error Alert tab.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
> "pkeegs" <[email protected]> wrote in message
> news:[email protected]...
> > Is there any VBA way that when a user enters an invalid name
> > into a cell with
> > validation that they can be prompted to add the new name to the
> > list?
>
>
>