How can I add an output option to my macro?

[liamdocherty]

How can I add a message pop up when the user clicks on my quit macro to display are you sure you want to quit the spreadsheet? With two options saying 'yes' and 'cancel'?

Sub CloseButton()
Application.Quit


End Sub

Thank you!

 

[liamdocherty]

Re: test

Could an admin update the title please? I didn't mean to call it that. Could it be changed to "How can I add an output option to my macro?"

 

[steveuk87]

Re: test

Sub CloseButton()

Msg1 = MsgBox("Are You Sure you want to Quit?", ybyesNo)
if Msg1 = yes then
Application.Quit
end if


End Sub