Detect which UDF params was chnaged
 

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

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

Detect which UDF params was chnaged
 

Thank you! Probably this will be implemented in a future version. What's
important for me now is that I am sure it's impossible via API.

Regards,
Nacho



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