How to know all UDFs are completed

Jul 22, 2014 at 7:19 PM
In one workbook, I have so many cells with MyUDF, MyUDF is an asynchronous UDF.
I will display a window with a spinner & cancel button, when all MyUDFs are completed, the window should be closed.

So I wonder if there is a way to know all MyUDFs are done?

Thanks
Coordinator
Jul 22, 2014 at 7:26 PM
Edited Jul 22, 2014 at 7:26 PM
There's no easy way provided by the ExcelAsyncUtil.Run feature for this. But in your UDF wrappers that should be easy to keep track of yourself.

-Govert
Jul 22, 2014 at 8:13 PM
Thanks.
Can I use Application.CalculateUntilAsyncQueriesDone ?
Coordinator
Jul 22, 2014 at 8:25 PM
No - that's not related.