VBA userform with a message prompt to save or exit without saving

Hello

I've created a VBA program and have included an EXIT button on a userform. I expect the EXIT button to prompt the user with the message "Do you wish to save the changes to this workbook" to confirm press YES or NO. If the user clicks YES then the program is saved and closed. If the user clicks NO the program/excel is closed down without saving.

This is what I have so far:


Private Sub CommandButton3_Click()
Dim MsgBoxResult As Long

MsgBoxResult = MsgBox("Do you wish to save the changes to this workbook" & vbCr & _
vbYesNoCancel)

If MsgBoxResult = vbCancel Then

Application.DisplayAlerts = False
Application.Quit

ElseIf MsgBoxResult = vbYes Then
ThisWorkbook.Save
Application.DisplayAlerts = False

End If
End Sub


When I click the EXIT button, the message pops up with an OK button but not a YES and NO button.

Any ideas??? Any help would be great!

Thanks all

Originally Posted by TMS

You have concatenated the parameters for the MsgBox. They should be separated with commas. Look at the Help for Msgbox ... or just start typing to see the prompts. When you type a comma, it will move on to the next one.

Regards, TMS

Thanks for your response.

I've tried rewriting the code following the prompts as you said but couldn't get it to work...

Do you have an example?

Thanks

TMS was referring to this;

Please Login or Register  to view this content.

These are the parameters of a msgbox. Notice the commas. They must remain to delineate the different parameters

Originally Posted by TMS

Please note ...

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Please Login or Register  to view this content.

Regards, TMS

That's great - it works perfectly. Thank you very much!!

Thanks stnkynts for your input and explanation as well.

Great forum!