Mimic Value Being Typed Into Cell
It's the OnEntry handler that has been setup by an add-in. Just
changing the cell value doesn't trigger the event, but I think a
combination of setting the activecell and calling the handler with Call
should do the trick...
thanks!
Tom Ogilvy wrote:
What event do you claim isn't being fired. Perhaps you have disabled
events, because the change event fires if the cell value is changed either
manually or by code. If you are using selection change, then you can have
your code select the cell if you need to fire the event.
|