Countdown Timer while sheet calculates

[RawlinsCross]

I have a dashboard that loads in a lot of information from a data base and does various amounts of manipulation. The entire process takes 2 minute.

I have the spreadsheet set up to automatically to re-calculate every 30 minutes or so to import all the new data. When the sheet recalculates I'd like a userform to appear that displays a 2 minute (2:00) countdown. Now while the two minutes is going on, all of the other code which I have stored under "Private Sub Workbook_SheetCalculate(ByVal sh As Object)" event will execute.

This is done to allow the user to see that new data is being imported.

Any ideas?

 

[MrTeeny]

You can stick up a progress bar if your code is using a loop which would be more meaningful than some arbitrary counter that may go on longer than your code