Show a message box, optionally setting a property value from the result.
| Overload Name | Description |
|---|---|
| General | Show a message box, optionally setting a property value from the result. |
| YesNo (7.7) | Show a YesNo prompt, optionally setting a property value from the result. |
| YesNoCancel (7.7) | Show a YesNoCancel prompt, optionally setting a property value from the result. |
Show a message box, optionally setting a property value from the result.
| 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>SheetNameSheetNumberAllSheets
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| Caption | The caption of the message box. |
| Message | The text to display in the message box. |
| Icon |
Specifies the icon that is displayed by a message box.
Specify one of the following values or an arbitrary value:
<blank>ErrorInformationNoneQuestionWarning
|
| Buttons |
Specifies the buttons that are displayed on a message box.
Specify one of the following values or an arbitrary value:
<blank>AbortRetryIgnoreOKOKCancelRetryCancelYesNoYesNoCancel
|
| DefaultButton |
Specifies the default button for the message box.
Specify one of the following values or an arbitrary value:
<blank>Button1Button2Button3
|
| Options |
Specifies options on a MessageBox.
Specify one of the following values or an arbitrary value:
<blank>DefaultDesktopOnlyRightAlignRtlReadingServiceNotification
|
| PropertyName | The name of the property created or set by the message box result. |
| PropertyDataType |
The data-type of the new property. Responses that return TRUE are Ignore, None, OK, Retry, and Yes. All other responses return FALSE. Return values for "string" include None, OK, Cancel, Abort, Retry, Ignore, Yes, No Return values for "integer" include None: 0, OK: 1, Cancel: 2, Abort: 3, Retry: 4, Ignore: 5, Yes: 6, No: 7
Specify one of the following values or an arbitrary value:
<blank>booleanintegerstring
|
Show a YesNo prompt, optionally setting a property value from the result.
| 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>SheetNameSheetNumberAllSheets
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| Caption | The caption of the message box. |
| Message | The text to display in the message box. |
| YesButtonCaption | The caption for the Yes button. |
| YesButtonPrompt | The text to place beside the Yes button. |
| NoButtonCaption | The caption for the No button. |
| NoButtonPrompt | The text to place beside the No button. |
| YesNoDefault |
Specifies the default button for the message box.
Specify one of the following values or an arbitrary value:
<blank>YesNo
|
| PropertyName | The name of the property created or set by the message box result. |
| PropertyDataType |
The data-type of the new property. Responses that return TRUE are Ignore, None, OK, Retry, and Yes. All other responses return FALSE. Return values for "string" include None, OK, Cancel, Abort, Retry, Ignore, Yes, No Return values for "integer" include None: 0, OK: 1, Cancel: 2, Abort: 3, Retry: 4, Ignore: 5, Yes: 6, No: 7
Specify one of the following values or an arbitrary value:
<blank>booleanintegerstring
|
Show a YesNoCancel prompt, optionally setting a property value from the result.
| 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>SheetNameSheetNumberAllSheets
|
| 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>FALSETRUE
|
| 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>FALSETRUE
|
| Caption | The caption of the message box. |
| Message | The text to display in the message box. |
| YesButtonCaption | The caption for the Yes button. |
| YesButtonPrompt | The text to place beside the Yes button. |
| NoButtonCaption | The caption for the No button. |
| NoButtonPrompt | The text to place beside the No button. |
| CancelButtonCaption | The caption for the Cancel button. |
| CancelButtonPrompt | The text to place beside the Cancel button. |
| YesNoCancelDefault |
Specifies the default button for the message box.
Specify one of the following values or an arbitrary value:
<blank>YesNoCancel
|
| PropertyName | The name of the property created or set by the message box result. |
| PropertyDataType |
The data-type of the new property. Responses that return TRUE are Ignore, None, OK, Retry, and Yes. All other responses return FALSE. Return values for "string" include None, OK, Cancel, Abort, Retry, Ignore, Yes, No Return values for "integer" include None: 0, OK: 1, Cancel: 2, Abort: 3, Retry: 4, Ignore: 5, Yes: 6, No: 7
Specify one of the following values or an arbitrary value:
<blank>booleanintegerstring
|