View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dag Johansen[_6_] Dag Johansen[_6_] is offline
external usenet poster
 
Posts: 4
Default Reason for calculation...

Hi,

is it possible to know in a custom function whether the
function is called as a result of one of it's dependants
having changed?

Example:

Cell formula "=myF(A5, C5)"

myF is now called if the value of cell A5 is updated. I
would like, in myF(), to detect this particular scenario.

Happy coding,

Dag