MsgBox Function

[darthy]

Is there a message box option that has a Yes and No button or Yes and Cancel that also has a Warning Icon on it. I have tried a few but cant seem to find the right one?

[Lightning]

MsgBox "bla", vbYesNo + vbExclamation

[McGenius]

If MsgBox("Would You Like To Exit Now?", vbQuestion + vbYesNoCancel, "Confirm Exit") = vbYes Then
    Unlaod Me
End If

[darthy]

Thanks Guys - Didnt realise you could choose 2 at the same time

[Frans C]

You can pass multiple messagebox constants by adding them together. However, you can not combine all constants. See below for details.
eg

If MsgBox("Are you sure?", vbYesNoCancel + vbQuestion, "Confirm please") = vbYes Then
    'format C
End If

From MSDN:
The buttons argument settings are:

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 default.
vbDefaultButton2 256 Second button is default.
vbDefaultButton3 512 Third button is default.
vbDefaultButton4 768 Fourth button is default.
vbApplicationModal 0 Application modal; the user must respond to the message box before continuing work in the current application.
vbSystemModal 4096 System modal; all applications are suspended until the user responds to the message box.
vbMsgBoxHelpButton 16384 Adds Help button to the message box
VbMsgBoxSetForeground 65536 Specifies the message box window as the foreground window
vbMsgBoxRight 524288 Text is right aligned
vbMsgBoxRtlReading 1048576 Specifies text should appear as right-to-left reading on Hebrew and Arabic systems


The first group of values (0–5) describes the number and type of buttons displayed in the dialog box; the second group (16, 32, 48, 64) describes the icon style; the third group (0, 256, 512) determines which button is the default; and the fourth group (0, 4096) determines the modality of the message box. When adding numbers to create a final value for the buttons argument, use only one number from each group.