That is why we have paragraphs.

the SelectionChange event can call the macro you assigned to onentry, but it
would call it before the cell value has been changed.

The code that changes the value in the cell could call the macro assigned to
your onentry event.

Two different thoughts. The "It" in the second sentence you cite was
referring to the subject of the first clause in the same sentence, not the
first sentence in the preceding paragraph.

If the selectionchange event is the macro which modifies the cell, then you
will have to sort that out, but it doesn't change the answer.

--
Regards,
Tom Ogilvy




"Matthew Wieder" wrote in message
...
I'm not sure I understand your response - you say that "No, setting the
activecell and calling the handler won't work" but then you say the
solution is "have it call the handler as well."
In your understanding, can I call the OnEntry handler or not from my
code automating the cell value change?
thanks,
-Matt

Tom Ogilvy wrote:
Onentry only fires when the cell is edited manually.

No, setting the activecell and calling the handler won't work unless you
mean selecting the cell and having the change event call the handler.
However, this would fire before the cell is edited which is probably not
what you want.

If you are having code modify the cell, then have it call the handler as
well.