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/

You might try using a worksheet calculate event and if it doesn't calculate
on the formula change, add =Now() somewhere on the worksheet.

--
Don Guillett
SalesAid Software

"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/

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/

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

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