Thread: visible counter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default visible counter

Hi Mike,

See John Walkenbach at:


http://www.j-walk.com/ss/excel/tips/tip34.htm


---
Regards,
Norman

"mike allen" wrote in message
...
I have a rather large loop (7,000+) that takes 4-5 minutes to run all the
way through. I would like to know my status in the loop as it progresses.
How do I get something like "2345 of 7000" to constantly show in the bottom
status bar (or elsewhere). I am assuming it will not slow the run time
much if at all. Thanks, Mike Allen