View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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