Calling Worksheet Change Event Directly from VBA

[biocentrism]

Is there a way to call a Worksheet Change Event using code?

I want to have the Worksheet Change Event execute as if the event actually occurred.

I have tried:

Call Worksheet_Change

but of course this did not work.

I read online that this was not possible. But I neither believe nor like this answer.

Thank you.

 

[biocentrism]

Not sure what you mean by linked. It was not linked as far as I am aware like a Form control is linked. But its event would increment the date in cell B1 by +1 or -1.

As for calling an event directly, I am a bit confused. Michael responded that it could be done but required serious coding written by Chip Pearson. Your example of passing a Range object is MUCH simpler and it works!!!

Do you know in what situation one would need to use Michaels/Chips solution?

Thank you.

 

[RoryA]

I mean had you set its LinkedCell property?

The code Michael referred to is for creating a worksheet_change event in code, not for calling an existing one.

 

[biocentrism]

No it was not linked.

Thank you for you insights!