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. |