Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data form not triggering Worksheet_Change event
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data form not triggering Worksheet_Change event
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data form not triggering Worksheet_Change event
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data form not triggering Worksheet_Change event
In article <7189aa38-a4ab-4ca3-9a91-52abeb5f7167
@d1g2000hsg.googlegroups.com, says... PS. Bret and Gompies are the same persons. Posted my question at work and replied at home ;o)) Kind regards, Bret |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |