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.

--
regards,
Tom Ogilvy

"Tornados" wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/