Once you click on a message box response, the box will go away automatically. You If statement will work when they click on Yes, as it should. The else can be ELSE confirm=7 Then.
You don’t need to put something in the ELSE part. If the user click on ‘NO’ or ‘CANCEL’, just do nothing (i.e. don’t use an ELSE).
Just make sure to put all your code to save and clear the form inside the IF part, then close the block (END IF) without an ELSE.