Collapse the table of content
Expand the table of content
Expand Minimize

Application.Ready Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .Ready

expression A variable that represents an Application object.

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
Show:
© 2016 Microsoft