The DefaultButton2 will change the Default Button to the 2nd button on the MessageBox, which in this case, is NO.

Code:
' Change the DefaultButton to NO.
RetVal = MsgBox("Message Box", vbYesNo + vbExclamation + vbDefaultButton2, "Message Box")