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" <pkeegs@discussions.microsoft.com> wrote in message
news:1BF261BB-4954-4A79-B9C1-2E190F4943D4@microsoft.com...
> 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" <pkeegs@discussions.microsoft.com> wrote in message
> news:1BF261BB-4954-4A79-B9C1-2E190F4943D4@microsoft.com...
> > 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?
>
>
>