Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up during calculation
I would like a temporary message box to appear momentarily when a macro is
activated. The macro typically takes 10 seconds or more to run and at the start i would like a box to pop up saying "calculation in progress" for a few seconds and then disappear without the need to press a button. Can anyone help? Thanks, Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up during calculation
Make a userform with the message you want to display, then show it at
the beginning of your procedure and close (unload) it at the end. Cliff Edwards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up during calculation
here's an option. create a userform with a label on it
Sub test() With UserForm1 .Show vbModeless .Label1.Caption = "Calculating...Please Wait" End With DoEvents Application.Wait (Now() + TimeValue("00:00:10")) Unload UserForm1 End Sub -- Gary "Roger on Excel" wrote in message ... I would like a temporary message box to appear momentarily when a macro is activated. The macro typically takes 10 seconds or more to run and at the start i would like a box to pop up saying "calculation in progress" for a few seconds and then disappear without the need to press a button. Can anyone help? Thanks, Roger |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up during calculation
This will do what you want:
http://support.microsoft.com/kb/148209 Regards, Ryan--- "Roger on Excel" wrote: I would like a temporary message box to appear momentarily when a macro is activated. The macro typically takes 10 seconds or more to run and at the start i would like a box to pop up saying "calculation in progress" for a few seconds and then disappear without the need to press a button. Can anyone help? Thanks, Roger |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up during calculation
I usually use
Application.StatusBar = "Enter your message" 'to display the message and Application.StatusBar = False 'to turn it off. -- HTH, Barb Reinhardt "Roger on Excel" wrote: I would like a temporary message box to appear momentarily when a macro is activated. The macro typically takes 10 seconds or more to run and at the start i would like a box to pop up saying "calculation in progress" for a few seconds and then disappear without the need to press a button. Can anyone help? Thanks, Roger |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up during calculation
Thanks - thats quite nice
Can one change the font to bold do you know? Regards, Roger "Barb Reinhardt" wrote: I usually use Application.StatusBar = "Enter your message" 'to display the message and Application.StatusBar = False 'to turn it off. -- HTH, Barb Reinhardt "Roger on Excel" wrote: I would like a temporary message box to appear momentarily when a macro is activated. The macro typically takes 10 seconds or more to run and at the start i would like a box to pop up saying "calculation in progress" for a few seconds and then disappear without the need to press a button. Can anyone help? Thanks, Roger |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up during calculation
Can one change the font to bold do you know?
No. The font and style of the StatusBar is fixed and cannot be changed,. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Roger on Excel" wrote in message ... Thanks - thats quite nice Can one change the font to bold do you know? Regards, Roger "Barb Reinhardt" wrote: I usually use Application.StatusBar = "Enter your message" 'to display the message and Application.StatusBar = False 'to turn it off. -- HTH, Barb Reinhardt "Roger on Excel" wrote: I would like a temporary message box to appear momentarily when a macro is activated. The macro typically takes 10 seconds or more to run and at the start i would like a box to pop up saying "calculation in progress" for a few seconds and then disappear without the need to press a button. Can anyone help? Thanks, Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
Calculation | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming |