The following table shows the constants you can use with the MsgBox function to identify what buttons and icons appear on a message box and which button is the default. In addition, you can specify the modality of MsgBox. Use these constants anywhere in your code in place of actual values.
Constant |
Value |
Description |
| vbOKOnly | 0 | Display OK button only. |
| vbOKCancel | 1 | Display OK and Cancel buttons. |
| vbAbortRetryIgnore | 2 | Display Abort, Retry, and Ignore buttons. |
| vbYesNoCancel | 3 | Display Yes, No, and Cancel buttons. |
| vbYesNo | 4 | Display Yes and No buttons. |
| vbRetryCancel | 5 | Display Retry and Cancel buttons. |
| vbCritical | 16 | Display Critical Message icon. |
| vbQuestion | 32 | Display Warning Query icon. |
| vbExclamation | 48 | Display Warning Message icon. |
| vbInformation | 64 | Display Information Message icon. |
| vbDefaultButton1 | 0 | First button is the default. |
| vbDefaultButton2 | 256 | Second button is the default. |
| vbDefaultButton3 | 512 | Third button is the default. |
| vbDefaultButton4 | 768 | Fourth button is the default. |
| vbApplicationModal | 0 | Application modal. A user must respond to the message box before continuing work in the current application. |
| vbSystemModal | 4096 | System modal. All applications are suspended until a user responds to the message box. |
The following table shows the constants you can use with the MsgBox function to identify which button a user chooses. Use these constants anywhere in your code in place of actual values.
Constant |
Value |
Description |
| vbOK | 1 | A user chose the OK button. |
| vbCancel | 2 | A user chose the Cancel button. |
| vbAbort | 3 | A user chose the Abort button. |
| vbRetry | 4 | A user chose the Retry button. |
| vbIgnore | 5 | A user chose the Ignore button. |
| vbYes | 6 | A user chose the Yes button. |
| vbNo | 7 | A user chose the No button. |