Run a macro when cell changes (due to calculation!)

  • Thread starter Thread starter Tornados
  • Start date Start date
T

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
 
You might try using a worksheet calculate event and if it doesn't calculate
on the formula change, add =Now() somewhere on the worksheet.
 
Not really.

the calculate event fires when a calculation occurs (which is what you say
change your cell), but there is not information passed on which cell caused
the sheet to recalculate. You could check the value of your cell in the
calculate event - however, if you only want the macro to run once - based on
a change, then it would be more complex, requiring you to store the old
value and make a comparison.

If the changes are caused by data coming in from a DDE connection, then you
could use the SetLinkOnData property. In Excel 2000 and later, however, the
Change event should fire in this case as well.
 
Well there is a dde feed that changes certain values. however, the cel
itself changes because of an if function that (because of the dd
change) changes its value..

And Yes indeed i would like a macro to be run one time when the valu
changes....

Thanks for the swift reaction though :). I hope someone can help me ou
here..

Thanks! Iv
 
Back
Top