Update Validation List from cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pkeegs - 21 Mar 2006 23:30 GMT

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?

Reply to this Message

Chip Pearson - 21 Mar 2006 23:54 GMT

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

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.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?

Reply to this Message

pkeegs - 22 Mar 2006 04:17 GMT

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

> Put the message to the user in the Error message box found on the
> Validation Dialog Error Alert tab.
[quoted text clipped - 3 lines]
> > validation that they can be prompted to add the new name to the
> > list?

Reply to this Message