Display popup message over a workbook while it's recalculating

[AE]

Hi all. I would like to display a popup message over a workbook while the user is waiting for it to recalculate. For example, the user clicks  "Recalc" button on the ribbon, Excel starts refreshing and while it is doing so I want to display an overlay message saying that the data is being loaded. Once the refresh is done, the popup should disappear.

Thanks!

[Kedar Kulkarni]

we have aftercalculate event below- you may be able to use these to determine if the calculation is completed. However it could become tricky if there are asynchronous formulas or RTD as excel could fire aftercalculate multiple times when any cell changes and may fire too early or too late for your process so use with caution. Try just showing a statusbar message first and then go for a non modal dialog.

https://learn.microsoft.com/en-us/office/vba/api/excel.application.aftercalculate

[AE]

Thanks, Kedar.