Results 1 to 3 of 3

Thread: modulus

  1. #1
    Join Date
    Apr 2006
    Posts
    47

    Unanswered: modulus

    i would like to update my status bar counting in blocks of 50.

    but it doesnt seem to work:

    If i \ 50 = 0 Then
    Application.StatusBar = "Row " & i
    End If

    also how would i reset my statbar

  2. #2
    Join Date
    Mar 2006
    Posts
    163
    \ isn't the operator for modulus.

    Try this.
    Code:
    If i Mod 50 = 0 Then
        Application.StatusBar = "Row " & i
    End If

  3. #3
    Join Date
    Feb 2006
    Posts
    113
    And reset with
    Code:
    application.StatusBar=false

Posting Permissions

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