View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default how do you set up a progress bar when running a macro in excel?

statusbar="running"
code
statusbar=""

--
Don Guillett
SalesAid Software

"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?