Ready Property [Excel 2003 VBA Language Reference]

  • Article

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

expression.Ready

expression Required. An expression that returns one of the objects in the Applies To list.

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."

Sub UseReady()

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

End Sub

Applies to | Application Object