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!!!
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!!!