9.0

207
Description
Show a message box titled Title$. Type controls what the message box looks like (choose one value from each
category). Use MsgBox( ) if you need to know what button was pressed. The result indicates which button was
pressed.
Result Value Button Pressed
vbOK 1 OK button
vbCancel 2 Cancel button
vbAbort 3 Abort button
vbRetry 4 Retry button
vbIgnore 5 Ignore button
vbYes 6 Yes button
vbNo 7 No button
Parameter Description
Message$ This string value is the text that is shown in the message box.
Type This numeric value controls the t
yp
e of messa
g
e box. Choose one value from each o
f
the following tables.
Title$ This string value is the title of the message box.
Button Value Effect
vbOkOnly 0 OK button
vbOkCancel 1 OK and Cancel buttons
vbAbortRetryIgnore 2 Abort, Retry, Ignore buttons
vbYesNoCancel 3 Yes, No, Cancel buttons
vbYesNo 4 Yes and No buttons
vbRetryCancel 5 Retry and Cancel buttons
Icon Value Effect
0 No icon
vbCritical 16 Stop icon
vbQuestion 32 Question icon
vbExclamation 48 Attention icon
vbInformation 64 Information icon
Default Value Effect
vbDefaultButton1 0 First button
vbDefaultButton2 256 Second button
vbDefaultButton3 512 Third button
Mode Value Effect
vbApplicationModal 0 Application modal
vbSystemModal 1000 System modal
Example
Sub Main
MsgBox "Please press OK button"
If
MsgBox("Please press OK button",vbOkCancel) = vbOK Then
Debug
.Print "OK was pressed"
Else
Debug
.Print "Cancel was pressed"
End
If
End
Sub