Detect which UDF params was chnaged

  • Thread starter Thread starter Nacho Nachev
  • Start date Start date
N

Nacho Nachev

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with UDF 3
UDF Looks for Named Range Not Function 2
Add-In UDF returning #NAME error 5
UDF: Roots of 1D Polynomials of Degree N and Real or Complex Coeff 10
Is it possible to retrieve the variable name of a property ? 1
I desperately need to know which autoshape is clicked, programmatically 5
Getting around Dependency Tree Performance Problems 3
Corrupt files due to pivot remnants after saving via VBA 0

Back
Top