Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
% completed box
I have a rather lengthy macro that basically loops through a long list of
company names. This macro takes appr. 20 minutes to run and therefore I would like to give the user some idea of how long time has gone/is left. What I would like is some sort of a message box that shows where the process is in the code. I have an integer that is the length of the list and another variable that is a counter. In terms of code: Assume i = position and k = length of list. For i= 1 to k ¦¦do some stuff Next Thus it would be really nice if I could have some message box that shows eg: Msgbox Number of companies searched: & I & . Total number of companies: & k Or something like that. Please help how to construct such a thing. Thank you very much!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
% completed box
Use a progress meter. Robin Hammond has a nice one at
http://www.enhanceddatasystems.com/E...rogressBar.htm -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Arne Hegefors" wrote in message ... I have a rather lengthy macro that basically loops through a long list of company names. This macro takes appr. 20 minutes to run and therefore I would like to give the user some idea of how long time has gone/is left. What I would like is some sort of a message box that shows where the process is in the code. I have an integer that is the length of the list and another variable that is a counter. In terms of code: Assume i = position and k = length of list. For i= 1 to k ..do some stuff Next Thus it would be really nice if I could have some message box that shows eg: Msgbox "Number of companies searched: " & I & ". Total number of companies: " & k Or something like that. Please help how to construct such a thing. Thank you very much!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Completed | Excel Worksheet Functions | |||
Finding the last completed row | Excel Discussion (Misc queries) | |||
If A1=X cell d1 must be completed before row 2 can be used | Excel Worksheet Functions | |||
IF completed THEN invisible | Excel Discussion (Misc queries) | |||
know when the job of print is completed? | Excel Programming |