Export (0) Print
Expand All
Expand Minimize

Application.Ready Property

Office 2007
Returns True when the Microsoft Excel application is ready; False when the Excel application is not ready. Read-only Boolean.

Syntax

expression.Ready

expression   A variable that represents an Application object.

Example

In this example, Microsoft Excel checks to see if the Ready property is set to True, and if so, a message displays "Application is ready." Otherwise, Excel displays the message "Application is not ready."

Visual Basic for Applications
Sub UseReady()

    If Application.Ready = True Then
        MsgBox "Application is ready."
    Else
        MsgBox "Application is not ready."
    End If

End Sub



Community Additions

ADD
Show:
© 2015 Microsoft