LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default msgbox as a progress indicator...

In other posts I have seen that the status bar has been suggested as the
prefered way to show macro progress...

The VBA that I am running swiches between several workbooks and with Screen
updating turned off, the WB that is open when the macro starts... is not the
one that has focus(in the background) where the status bar would display (if
it even would show changes with screen updating off).

what would be a good way to have the current section being executed always
show?

I'd like to have a msgbox popup for this, but I dont want the "OK" button to
sit there a wait for a press. Is there some way to define a seperate box or
form that can display the status message?

Will I have to toggle screen updating on to show it, then toggle it back off?
and, I assume that I would have to swap the active workbook.worksheet to
make sure it has the focus.

suggestions?
--
Regards,
John
 
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
MS Progress Indicator Mimicked. Thank you. JK Excel Programming 0 August 22nd 04 10:26 PM
Mimick MS Progress Indicator? JK Excel Programming 7 August 22nd 04 07:57 PM
UserForm as Progress Indicator MWE Excel Programming 6 January 19th 04 03:22 PM
PROGRESS INDICATOR jason Excel Programming 6 October 3rd 03 01:58 AM
Popup Progress Indicator David W[_3_] Excel Programming 1 August 18th 03 08:29 PM


All times are GMT +1. The time now is 01:26 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"