modulus

MikeroSoft · #1 (**permalink**) 06-01-06, 14:15

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

norie · #2 (**permalink**) 06-01-06, 15:11

\ isn't the operator for modulus.

Try this.

Code:

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

Fazza · #3 (**permalink**) 06-05-06, 20:54

And reset with

Code:

application.StatusBar=false

Internet Services

Web Development

Digital Marketing

Consumer Tech