If this is in QueryUnload, you don't need to call Unload Me because your form will unload unless you set the Cancel parameter in that event to non-zero.
Code:
If MsgBox("Are you sure", vbYesNo, "Quit") = vbYes Then
    
Else ' No was pressed

End If