Expand Minimize

Application.Ready Property (Excel)

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:
© 2015 Microsoft