Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cancel Validation and Change Event
Hi,
I'm using a change event to run a routine whenever a specific cell (B3) changes. That cell uses Excel's data validation tool to restrict the number of values that can be entered. The change event macro works fine whenever the user enters a valid value. However, it also runs whenever the user enters an invalid value and then clicks "Cancel" on the validation tool pop- up error message. Is there any way to keep the macro from running if the user attempts to cancel the data entry attempt? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Procedure with a worksheet change event | Excel Worksheet Functions | |||
Cancel sheet change event | Charts and Charting in Excel | |||
Validation not triggering Change event in Excel XP | Excel Programming | |||
Validation not triggering Change event in Excel XP | Excel Programming | |||
Worksheet Change Event With Validation List | Excel Programming |