Excel StatusBar update not working (VBA)

[RosieMP]

GAH!

Not sure whether this is the right forum for this one...

Can anyone suggest why my status bar isn't working?

If rRaw Mod 100 = 0 Then
Application.StatusBar = "Processed " & Format((rRaw / BottomRow), "%")
Else
Application.StatusBar = "whatevah"
End If

Even with bad variables I should get "whatevah" but I get nothing but the title of the Excel doc -- it never updates at all.

 

[combo]

Look at the bottom-left corner of excel window. "%" will return only empty '%' sign, try "#.00%" instead.

combo

 

[RosieMP]

Wow, I feel like a moron. I was looking in the wrong place.

But I feel like a moron with the right answer, which is the important thing.

Thanks!

 

[combo]

If you like to change titles:

Application.Caption = "replaces 'Excel'"
Application.ActiveWindow.Caption = "replaces 'Book'"
Application.Caption = "" ' reset application name
Application.ActiveWindow.Caption = False 'reset workbook name

combo