MsgBox with VBYesNoCancel

[NeedForExcel]

Hey!!

If suppose I write a code where at the time of closing the workbook a message box appears asking me if I wanted to make a back up of this file.

Clicking Yes would Make a back Up
Clicking No would Exit Workbook
And Clicking cancel would just cancel the Msg Box.

How should I write the code for the cancel button.

I have already written codes for the yes & no buttons.

Please Login or Register  to view this content.

[AndyLitch]

Selecting cancel prevents the workbook from closing

Please Login or Register  to view this content.

[NeedForExcel]

Perfect!!

Thank You.

Marking the thread as solved!