MsgBox Instruction/Function
Syntax
MsgBox Message$[, Type][,
Title$]
-or-
MsgBox(Message$[, Type][,
Title$])
Group
User
Input
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
type of message box. Choose one value from each of 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"
EndIf
End Sub