| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message box whilst calculating
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Message box whilst calculating
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Message box whilst calculating
Have a look he
http://www.j-walk.com/SS/excel/tips/tip34.htm Corey.... "Barb Reinhardt" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Message box whilst calculating
Don't know how fancy you want to get, but check this site.
http://www.j-walk.com/SS/excel/tips/tip34.htm "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display message while calculating forumlas | Excel Discussion (Misc queries) | |||
| Calculating: (1 Processor(s)): 25% MESSAGE ON STATUS BAR | Excel Discussion (Misc queries) | |||
| Calculating Cells n% message in Status bar | Excel Discussion (Misc queries) | |||
| Display a message whilst a macro runs | Excel Programming | |||
| Display a message whilst a macro runs | Excel Programming | |||
Hybrid Mode
