How can I display status bar value in Excel 2007

A

Al B

I want to use the values displayed in the status bar during macro execution
to display progress graphically. Is this possible?
 
Z

Zone

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
 
Top