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: 33
Default progress message in status bar

Using Excel 2000.

I want to display a message in the status bar when
processing passes certain milestones (number of rows
processed). At the moment I am doing it like this:

If lngRows 20000 Then
Application.StatusBar = "20000 rows processed. Still
going . . ."
Exit Sub
End If
If lngRows 15000 Then
Application.StatusBar = "15000 rows processed. Still
going . . ."
Exit Sub
End If
If lngRows 12500 Then
Application.StatusBar = "12500 rows processed. Still
going . . ."
Exit Sub
End If

At the moment I have milestones at 250, 500, 750, 1000,
then I go up in 1000's, then 2500's and eventually
5000's - all the way out to 50000 rows.

The way the macro increments the counter, lngRows, may
not exactly match a milestone, so that is why I use
rather than =.

This seems a rather clunky way of doing this. Is there a
more streamlined way?


 
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
configuration progress message Yas Excel Discussion (Misc queries) 2 February 10th 08 06:31 PM
Excel Status Progress Bar Ai Excel Programming 2 May 28th 04 01:41 PM
Status Message Ray Batig Excel Programming 4 December 26th 03 03:25 AM
How to create a message box to keep track of progress Jeff Armstrong Excel Programming 1 October 30th 03 06:52 PM
progress message GUS Excel Programming 1 September 12th 03 04:27 PM


All times are GMT +1. The time now is 03:20 AM.

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"