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.