Executing a Macro after a cell changes due to a ''new" calculation

[Tornados]

Goodday,

I tried to use the worksheet change functions, yet they only seem to act
when you actively enter into a certain cell.

However i need to call a certain macro when the output in a certain cell
changes due to the change in the specific if function. Therefore without
user intervention.

Is there any way to do this?

Kind regards,

Ivo Geijsen
[email protected]

 

[Dave Peterson]

You have one guess at your other post:

Take a look at the worksheet_calculate event.