Detect which UDF params was chnaged
If you mean which cell changed to generate a calculate event, there is no
readily available way to determine that. You would have to store the old
values of the parameters and compare to the current values.
--
Regards,
Tom Ogilvy
"Nacho Nachev" wrote in message
...
Hi,
These days I am obviously asking too twisted question, and here's another
one: Is it possible to retrieve information which is the changed parameter
that has caused the invocation of VBA based user-defined function?
I am more interested in a solution via API rather than application logic,
which seems to be quite complicated to created.
Thanks for your time,
Nacho
|