MsgBox
MsgBox(prompt[, okCancel])
Description
MsgBox opens a dialog box, and waits for the user to tap on a button. The return value is an integer that indicates which button was tapped. The required parameter, prompt, is a string expression that is displayed in the body of the dialog box. The optional parameter, okCancel, is a numeric or constant expression that specifies whether to ask the user to choose between a Cancel and Ok. The default value for okCancel is 0.
Table 15: okcancel constants
| Constant | Value | Description |
|---|---|---|
| vbOKOnly | 0 | OK Button only |
| vbOKCancel | 1 | OK and Cancel Buttons |
Table 16: MSGBOX return values
| Constant | Value | Description |
|---|---|---|
| vbOK | 1 | OK |
| vbCancel | 2 | Cancel |
Example
Rem MsgBox Example
'MsgBox displays a modal dialog box
Dim Continue
MsgBox("Hello World!")
MsgBox "Brief tour of MSGBOX", vbOK
Continue = MsgBox("Continue tour?", 1)
If Continue = vbYes Then
Continue=MsgBox("Short tour, huh?")
End If
Continue = MSGBOX("Repeat tour?", 1)
If Continue = vbCancel Then
MSGBOX("Goodbye!")
End If
Output
