brothertruffle880
asked on
Excel VBA 2013: Why do I need the word APPLICATION in my status bar message?
Why do I need the word "application" before "statusbar". Why not just "status bar"?
I don't use "application" in other lines of code in my macro.
Sub test()
Application.StatusBar = "Please be patient..."
End Sub
I don't use "application" in other lines of code in my macro.
Sub test()
Application.StatusBar = "Please be patient..."
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you both!
From what I was taught, the StatusBar needs to be represented using an expression/Application object. In other words, you need a reference or variable in front of it to let it know which expression or function you want the StatusBar to work on.