View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default Data form not triggering Worksheet_Change event

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

--
Jim
"Gompies" wrote in message
...
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?