Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to use the values displayed in the status bar during macro execution
to display progress graphically. Is this possible? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
display status bar value in excel userform? | Excel Discussion (Misc queries) | |||
My Excel 2007 doesn't have a status bar, pls show me how? | Excel Discussion (Misc queries) | |||
How do I change the display options in the status bar of MS Excel | Excel Discussion (Misc queries) | |||
display count/results of filtering Excel in status bar | Excel Discussion (Misc queries) | |||
Display No. of Rows in Status Bar | Excel Discussion (Misc queries) |