% completed box

nada

Board Regular
Joined
Jul 4, 2006
Messages
193
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!!!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,141,094
Messages
5,704,306
Members
421,337
Latest member
DeuxMilleSangue

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top