Results 1 to 8 of 8

Status Bar as progress bar

Threaded View

  1. #1
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,177

    Status Bar as progress bar

    Im forgetting how to code something for this.
        For lRow = Range("A1").End(xlDown).Row To 2 Step -1
    Application.StatusBar = Range(lRow).Cells & " of " & lRow & " complete."
            If Left(Cells(lRow, "A").Value, 9) <> "     $$ #" Then
                Rows(lRow).EntireRow.Delete xlUp
            Else
                Rows(lRow).Select    'visual aid
                'Selection.Font.ColorIndex = 3 'for testing
            End If
            
        Next lRow
    Im trying to show what row of the total rows are in process in the status bar.

    Any help, tips, hints, etc is appreciated.
    Last edited by Rick_Stanich; 04-29-2009 at 03:56 PM.
    Regards

    Rick
    Win10, Office 365

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1