Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
display status bar value in excel userform? Al B Excel Discussion (Misc queries) 0 November 15th 06 01:21 PM
My Excel 2007 doesn't have a status bar, pls show me how? InDistressWithExcel Excel Discussion (Misc queries) 1 August 17th 06 09:09 PM
How do I change the display options in the status bar of MS Excel Baffled Excel Discussion (Misc queries) 1 November 15th 05 05:34 PM
display count/results of filtering Excel in status bar JayDax Excel Discussion (Misc queries) 2 July 21st 05 11:41 PM
Display No. of Rows in Status Bar Marty Excel Discussion (Misc queries) 2 January 24th 05 10:29 PM


All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"