Ready Property

Microsoft Excel Visual Basic

Ready Property

       

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