Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
message box
Hello,
I have a code that runs for about 2 minutes. I understand that in Excel there is no possibility of displaying the state of a lenghty calculation with a progress bar. I do have a message displayed in the status bar while code is running, but it is not enough. Is there a way that I can have a message box displaying random texts (i.e.,"tip of the day") until calculations are completed? Thanks in advance for any light you can give me. Myriam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
message box
Hi Myriam
See John Walkenbach's page http://j-walk.com/ss/excel/tips/tip34.htm and replace the progress indicator with other nice things. HTH. best wishes Harald "Myriam" skrev i melding ... Hello, I have a code that runs for about 2 minutes. I understand that in Excel there is no possibility of displaying the state of a lenghty calculation with a progress bar. I do have a message displayed in the status bar while code is running, but it is not enough. Is there a way that I can have a message box displaying random texts (i.e.,"tip of the day") until calculations are completed? Thanks in advance for any light you can give me. Myriam |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
message box
Thanks. Exactly what I needed! Great link!
"Harald Staff" wrote: Hi Myriam See John Walkenbach's page http://j-walk.com/ss/excel/tips/tip34.htm and replace the progress indicator with other nice things. HTH. best wishes Harald "Myriam" skrev i melding ... Hello, I have a code that runs for about 2 minutes. I understand that in Excel there is no possibility of displaying the state of a lenghty calculation with a progress bar. I do have a message displayed in the status bar while code is running, but it is not enough. Is there a way that I can have a message box displaying random texts (i.e.,"tip of the day") until calculations are completed? Thanks in advance for any light you can give me. Myriam |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
message box
Hi Myriam:
"Myriam" wrote: Hello, I have a code that runs for about 2 minutes. At the end of the day the code is still 2 minutes with or without progress bars, message boxes or whatever. Maybe you could break up the procedeure and get somthing on screen in more of an acceptable time frame. Good Luck TK |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
message box
Hi, TK:
Thanks for your comment. However, this is not possible. It's a summary calculation of a project with quite a few workbooks. No way to get around it. Thanks for the encouragement... Regards, Maybe you could break up the procedeure and get something on screen in more of an acceptable time frame. "TK" wrote: Hi Myriam: "Myriam" wrote: Hello, I have a code that runs for about 2 minutes. At the end of the day the code is still 2 minutes with or without progress bars, message boxes or whatever. Maybe you could break up the procedeure and get somthing on screen in more of an acceptable time frame. Good Luck TK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pop-Up Message | Excel Discussion (Misc queries) | |||
Message Box | Excel Discussion (Misc queries) | |||
Message Box - more help please !! | Excel Worksheet Functions | |||
changing the message in an error message | Excel Worksheet Functions | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming |