Prev: My CD won't let me save my Excel workbook on them?
Next: Custom Footer
From: Ian82 on 31 Mar 2010 03:49
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
From: Dave Peterson on 31 Mar 2010 08:26
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
 | 
Pages: 1
Prev: My CD won't let me save my Excel workbook on them?
Next: Custom Footer