MsgBox Constants

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.