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> 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
|
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> Error Information None Question Warning
|
Buttons |
Specifies the buttons that are displayed on a message box.
Specify one of the following values or an arbitrary value:
<blank> AbortRetryIgnore OK OKCancel RetryCancel YesNo YesNoCancel
|
DefaultButton |
Specifies the default button for the message box.
Specify one of the following values or an arbitrary value:
<blank> Button1 Button2 Button3
|
Options |
Specifies options on a MessageBox.
Specify one of the following values or an arbitrary value:
<blank> DefaultDesktopOnly RightAlign RtlReading ServiceNotification
|
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> boolean integer string
|
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> 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
|
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> Yes No
|
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> boolean integer string
|
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> 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
|
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> Yes No Cancel
|
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> boolean integer string
|