Pauses execution of the current procedure.
Overload Name | Description |
---|---|
General | Pauses execution of the current procedure for a specified number of seconds. |
Until | Pauses execution of the current procedure until a specified condition is met. |
Pauses execution of the current procedure for a specified number of seconds.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Seconds | The number of seconds to wait. Specified as a decimal value with a minimum of .0001 seconds. |
Pauses execution of the current procedure until a specified condition is met.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
UntilCondition | A formula to evaluate after each interval to determine whether to end the wait. |
IntervalSeconds | The number of seconds between evaluations of the UntilCondition. Specified as a decimal value with a minimum of 0.0001 seconds. If left blank IntervalSeconds will default to 1. |
IntervalProcedure | A procedure to run for each interval before the evaluation of UntilCondition. This optional procedure might be used to set a property to be evaluated in the UntilCondition. |
MaxIterations | Limits the number of times the UntilCondition is evaluated and the Wait is terminated. If left blank MaxIterations will default to 10. |
MaxIterationsAction |
What to do if the Wait is terminated because MaxIterations has been reached. If left blank then ThrowException will be used.
Specify one of the following values or an arbitrary value:
<blank> Nothing DisplayMessage ThrowException
|
MaxIterationsMessage | The message to display if MaxIterations is reached. |