Add Cancel in the message box

[RJ1969]

Hello all,
Is there anyway to add a "cancel" in this code?

I only see "OK" when a button is clicked.

Thanks.

Please Login or Register  to view this content.

[gue2013]

here you can find everything
https://docs.microsoft.com/en-us/off...sgbox-function

[RJ1969]

Sorry Gue,
I am not really familiar with the VBA if you can please tell me how to add this then.

vbOKCancel

Thanks.

[RJ1969]

I need to edit this code to add this : vbOKCancel

[RJ1969]

Hi
Ok, I was able to add it but when I click the button and I click the "cancel", the worksheet still save. Please edit the code. Thank you.

Please Login or Register  to view this content.

[gue2013]

Please Login or Register  to view this content.

your code:
if you first save your workbook with

Please Login or Register  to view this content.

then the next line

Please Login or Register  to view this content.

makes no sense.
Setting saved to True means that a modified workbook will be closed without either saving it or being prompted to save it. You can skip this line.

[RJ1969]

Please Login or Register  to view this content.

This is what I have so far, but after some of my entry and I click the button and I cancel. It still saved it

[gue2013]

yes because your first statement says "save the workbook"

change it to

Please Login or Register  to view this content.

[RJ1969]

Yay! Thank you Gue.