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

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

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