MsgBox(prompt[, buttons] [, title])
The buttons argument settings are:
Constant | Value | Description |
---|---|---|
OKOnly | 0 | Display OK button only. |
OKCancel | 1 | Display OK and Cancel buttons. |
AbortRetryIgnore | 2 | Display Abort, Retry, and Ignore buttons. |
YesNoCancel | 3 | Display Yes, No, and Cancel buttons. |
YesNo | 4 | Display Yes and No buttons. |
RetryCancel | 5 | Display Retry and Cancel buttons. |
Critical | 16 | Display Critical Message icon. |
Question | 32 | Display Warning Query icon. |
Exclamation | 48 | Display Warning Message icon. |
Information | 64 | Display Information Message icon. |
DefaultButton1 | 0 | First button is default. |
DefaultButton2 | 256 | Second button is default. |
DefaultButton3 | 512 | Third button is default. |
ApplicationModal | 0 | Application modal; the user must respond to the message box before continuing work in the current application. |
SystemModal | 4096 | System modal; all applications are suspended until the user responds to the message box. |
MsgBoxSetForeground | 65536 | Specifies the message box window as the foreground window |
MsgBoxRight | 524288 | Text is right- aligned |
MsgBoxRtlReading | 1048576 | Specifies text should appear as right-to-left reading on Hebrew and Arabic systems |
The first group of values (0–5) describes the number and type of buttons displayed in the dialog box; the second group (16, 32, 48, 64) describes the icon style; the third group (0, 256, 512) determines which button is the default; and the fourth group (0, 4096) determines the modality of the message box. When adding numbers to create a final value for the buttons argument, use only one number from each group.
Note These constants are specified by Visual Basic for Applications. As a result, the names can be used anywhere in your code in place of the actual values.
Return Values
Constant | Value | Description |
---|---|---|
OK | 1 | OK |
Cancel | 2 | Cancel |
Abort | 3 | Abort |
Retry | 4 | Retry |
Ignore | 5 | Ignore |
Yes | 6 | Yes |
No | 7 | No |
If the dialog box displays a Cancel button, pressing the ESC key has the same effect as clicking Cancel. If the dialog box contains a Help button, context-sensitive Help is provided for the dialog box. However, no value is returned until one of the other buttons is clicked.
Note To specify more than the first-named argument, you must use MsgBox in an expression. To omit some positional arguments, you must include the corresponding comma delimiter.
InputBox Function | Returning Strings from Functions