Data form not triggering Worksheet_Change event

[Gompies]

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?

 

[IanKR]

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.

 

[IanKR]

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.

Please ignore my post - it's wrong. I managed to get the Change event to
fire in these circumstances, so I'm afraid I don't know the answer to your
problem. Apologies.

However, I have had problems in these circumstances before. There are
occasions when you'd expect the Change event to fire - but doesn't - and the
Calculate event does fire, which does the trick. Could you post your code?

 

[Jim Rech]

But data entry with the Data Form won't fire this change event.

That does seem to an problem. The calc event idea maybe isn't so good
because there is no way to know which cell changed. You might try this
alternative to the built-in Data form from John Walkenbach. It's a better
answer in any case and (I assume) it doesn't block the change event.


http://spreadsheetpage.com/index.php/dataform/home