Target with worksheet_calculate

[AEGuy]

Hi everyone,


I am trying write a code that will perform an action when the value of a specific cell changes with an excel formula. In order for it to execute properly, the code needs to be passed the cell that changed value.

I can easily do this using

 worksheet_change(ByVal Target as Range)

and using the target object, but I am trying to get the sub to execute when a formula changes the value of the cell, and I can't find an analogous object using

 worksheet_calculate()

.

Is there something that I am missing? I'm sorry if there is a straightforward answer; I'm fairly new to VBA.

 

[Debaser]

There is no such object. The entire sheet calculates, not a specific cell. Typically, you either store the old value of the cell(s) of interest, and then check those in the Calculate event to see if they have changed, or you monitor the input cells for the formulas using a Change event.