Loading Screen Whilst Calculating

[mouse88]

Does anyone know a way of showing a user form as a loading screen whilst the workbook is calculating all the formulas.

I know how to show the form but not how to check if the calculations are complete.

 

[VoG]

Try using

If Application.CalculationState = xlDone then
'
'your code
'
End If

 

[zjat]

Hi Peter or anyone else

Can you be more specific - I wish to make a "please wait" message and show how many percent of the file there is calculated when calculating, so the user know they have to wait. There should be a cancel calculation as well on the "please wait" message.