View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Keith[_2_] John Keith[_2_] is offline
external usenet poster
 
Posts: 175
Default how do you set up a progress bar when running a macro in excel?

I was about to ask almost the same question (and this was the top post)

I want to display some type of message as the macro starts... then when its
done, have the message go away. something like "Please wait, Macro running".

The progress indicator would be nice to have as well...


"Neil Hopkinson" wrote:

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?