Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet_Change event not running from Form control. | Excel Programming | |||
data validation list does not trigger worksheet_change event | Excel Programming | |||
Problem with Data Validation Dropdown List / Worksheet_Change Event | Excel Programming | |||
MS Bug? Data validation list dropdown with Worksheet_Change event | Excel Programming | |||
auto-filter change not triggering worksheet_change event | Excel Programming |