Displaying Excel calculation progress

Question

Is there a way to access the Calculating Cells percentage displayed on the status bar when Excel is recalculating? I would like to display a progress bar of this when Excel is doing lengthy recalculations in order to let impatient users know that something is happening.

Regards,

Mark

Answer 1

Am 21.10.2010 15:32, schrieb Marklap:

Excel is doing a complete recalculation when I set application.calculation=xlCalculationAutomatic at the end of the VBA routines.

What I would like to do is map the calculation progress displayed in the status bar on to a more prominent display - maybe a non modal form?

A modeless userform and "Application.Cursor = xlWait" is your only choice, there is no way to get the percentage of the calculation that excel does.

Andreas.

Sub Test()

  WaitMessage.Show vbModeless

  Application.Cursor = xlWait

  Application.Calculation = xlCalculationAutomatic

  Application.Cursor = xlDefault

  Unload WaitMessage

End Sub

Answer 2

Many thanks you for your replies.

Answer 3

Thanks Mike,

I am not actually running any code at the time Excel is doing its calculation so I have no loop to increment the progress bar with. I am importing data files onto several worksheets which contain formulae and Excel is doing a complete recalculation when I set application.calculation=xlCalculationAutomatic at the end of the VBA routines. I have tried recalculating each sheet when its data has been imported and before importing data for the next sheet, but Excel still seems to do a complete recalculation at the end lasting several minutes, sometimes displaying the 'Not Responding' message in the Title Bar, which leads the user to think it has fallen over.

It also annoyingly seems to trigger a lengthy recalculatin the first time I select a different sheet tab.

What I would like to do is map the calculation progress displayed in the status bar on to a more prominent display - maybe a non modal form?

Regards,

Mark

Answer 4

Hi,

Have a look here

http://www.cpearson.com/excel/Progress.htm

---

If this post answers your question, please mark it as the Answer.

Mike H