Command Button with macro

I have a simple purchase order that has two buttons. One button print/save, I have that working Okay. The other button I want to use a message box to ask if you want a new purchase order, if no is selected exit sub. If yes is clicked, it needs to clear certain cells and add one to a cell to create the new invoice.

I can get these to work individually, but not on the same button.

Appreciate some help!

I have attached the file...it does have a macro.
OR
Below is VBA:

Please Login or Register  to view this content.

Hello GJR,

Please use this code for the "Other" Button.

Please Login or Register  to view this content.

Regards

Hello GJR,

You are welcome.

Glad I could help. Thank you for correcting your thread, and for adding to my Reputation.

Hope you are marking this thread as Solved. Edit: Done. Thank You!

Regards.