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

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

You have to use the CreateWindowEx API function if you want to create a real
progress bar. Here's an article that may already have been submitted
http://www.dicks-blog.com/archives/2.../progress-bar/

/Fredrik


Reply With QuoteReply With Quote