View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 25
Default how do you set up a progress bar when running a macro in excel?

Hi Neil,

a few more site that might be helpfull:
http://j-walk.com/ss/excel/tips/tip34.htm
http://www.dicks-blog.com/archives/2.../progress-bar/

a nice example:
http://www.oaltd.co.uk/DLCount/DLCou...e=WksPrgrs.zip

hope u can use this!!

"Neil Hopkinson" <Neil wrote in message
...
I have written a macro which takes a minute or so to run. I want to set up
a
progress bar so the user can see something happening and knows the program
hasn't crashed. How do I do this?