Yes/No Msgbox question - set Default response to 'No'

[jfarc]

In the sample question Msgbox below the 'Yes' answer is the Default (If user simply hits the 'Enter' key as their response).

If vbYes = MsgBox("My Question", vbYesNo, "Confirm Answer") Then

Is there a way to have exactly the same question Msgbox as above, but have the 'No' as the Default?

 

[Kenneth Hobson]

If vbNo = MsgBox("My Question", vbYesNo, "Confirm Answer") Then

 

[VoG]

Try

If vbYes = MsgBox("My Question", vbYesNo + vbDefaultButton2, "Confirm Answer") Then

 

[jfarc]

Perfect VoG! Just what I was looking for.

Thanks Kenneth, but that still left the 'Yes' response as the Default. Gets very confusing to ask a negative question and answer with a 'Yes' to result the opposite meaning of the intended question. See I told you it's confusing!

 

[sctlippert2]

If vbYes = MsgBox("My Question", vbYesNo + vbDefaultButton2, "Confirm Answer") Then

To get a true negative unless you clicked on "Yes", I used

If vbYes <> MsgBox("My Question", vbYesNo + vbDefaultButton2) Then