Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Validation List from cell
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" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Validation List from cell
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
How to update edited values in validation list? | Excel Discussion (Misc queries) | |||
Auto Update validation list? | Excel Worksheet Functions | |||
Update Validation List | Excel Discussion (Misc queries) | |||
Auto Update A Validation List | Excel Worksheet Functions |