Hi All

I need a macro to pop up a msg box to indicate that the sheet is calculating
and how far along it is, any ideas?

Thanks

You can't really do this in excel. You can't get into the calculation internal
workkings.

But if you're doing it in code, you could show a msgbox:

msgbox "about to calculate"
application.calculate
msgbox "Done calculating"

But I think that this just delays the calc--since the msgbox has to be dismissed
before the calculation starts.

You could use a non-modal userform (xl2k or higher) or even the statusbar:

with application
.statusbar = "Calculating"
.calculate
.statusbar = false
end with




Ian82 wrote:

Hi All

I need a macro to pop up a msg box to indicate that the sheet is calculating
and how far along it is, any ideas?

Thanks

--

Dave Peterson