Message box whilst calculating

[Rick]

I have created a macro which formats and copies data then when it has
finished it recalculates all the formulas.

This takes a little while.

How do I bring up a message box whilst it is calculating saying "
Calculating..." and and new box with "finished", once the file has finished
calculating.

Thanks
rick

 

[Barb Reinhardt]

You can't do a message box, per se, but you could put up a status bar. I
think that when it's calculating, you see something in the status bar anyway.

Application.StatusBar = "Calculating"
do the calculation
Application.StatusBar = FALSE
MsgBox("Calculation Complete")

 

[JLGWhiz]

Don't know how fancy you want to get, but check this site.

http://www.j-walk.com/SS/excel/tips/tip34.htm

 

[Corey]

Have a look here:
http://www.j-walk.com/SS/excel/tips/tip34.htm


Corey....

 

[Rick]

thanks, that'll do it.

You can't do a message box, per se, but you could put up a status bar. I
think that when it's calculating, you see something in the status bar anyway.

Application.StatusBar = "Calculating"
do the calculation
Application.StatusBar = FALSE
MsgBox("Calculation Complete")