Data form not triggering Worksheet_Change event
I'm trying to input some data in a worksheet with the build in Data
Form. After insertion I want a to trigger the Worksheet_Change event
(to validate the input). But data entry with the Data Form won't fire
this change event.
Is there some workaround?
Use the Worksheet_Calculate event instead. The Worksheet_Change event is
fired only when the user changes the worksheet directly, and not via a
userform.
|