How can I display status bar value in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use the values displayed in the status bar during macro execution
to display progress graphically. Is this possible?
 
I use the pipe (Shift+Backslash) to do this:
Application.Statusbar=" processing |||||"
' your code here. Add more pipes at points in your code like this:
Application.Statusbar=Application.Statusbar & "|||||"
You'll have to play with it to see how many pipes are appropriate and where
to put them.
When finished with your code, be sure to include
Application.Statusbar=False
to return the Statusbar to normal operation.
This is a simple way to do it. It shows up quite well. It doesn't show
percentage of completion (such as 75%), but you could add that fairly
easily.
HTH,
James
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top