On the Worksheet Change event

When changing a cell contents, will trigger the Worksheet Change event.
I realized some data input and storage function with EXCEL, after a series of operations, Worksheet Change did not trigger the event, this is why?

Because this does not have any law, also do not know this from happening again in what condition, so I don't know how to change the code.
When this occurs, not restart the EXCEL file, the Change event will no longer trigger. But the other button event can still use. As for the other events of Worksheet I haven't noticed there is no failure.

Started by Elmer at December 25, 2016 - 4:09 PM


Posted by Elmer at January 07, 2017 - 5:09 PM

There is no middle exit code?

Posted by Francis at January 10, 2017 - 5:38 PM

There will be so strange?

Posted by Irene at January 11, 2017 - 6:14 PM

There is no exit, set breakpoints in the event, the breakpoint without interruption.
Data from the point of view, is not the implementation of Change events.

Posted by Elmer at January 15, 2017 - 5:47 PM