How can I display status bar value in Excel 2007
 

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

How can I display status bar value in Excel 2007
 

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
"Al B" wrote in message
...
I want to use the values displayed in the status bar during macro execution
to display progress graphically. Is this possible?