Message box whilst calculating
thanks, that'll do it.
"Barb Reinhardt" wrote:
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")
--
HTH,
Barb Reinhardt
"Rick" wrote:
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
|