Warning Message needed prior to clearing spreadsheet

Hi Everyone!

I have been asked to modify an existing macro in a workbook and I'm not sure where to start with the request. The main sheet has a macro that is attached a button that starts the macro running. It's a simple macro that when the button is pushed it start clearing cells as needed. I'd like to add a warning message prior to any clearing of cells that ask, "Are you sure you want to clear cells?". The person would need to answer with a Yes/ No application, "Yes" to continue or "No" to end the macro from running. Any help would be greatly appricated. Thanks in advance!!

JRTDCG

Hi Jeff!!
Worked perfect...Thank you so much for the quick reply and answer to my question.
Best Regards- J.R.

hi jeffrey,

I am in learning stage of macro. if you don't mind, can you pls tel me y we have to use second line for buttons, Y it is not allowing me to write 1 line itself. Thanks in advance

ooops, sorry. I will rephrase it. In the below code what u have given, After underscore u have taken second line. when I try to write same on my Excel it throws a error. Bcs I write it on single line. Hope, I am clear now. As I have seen the above code & got the doubt. I just raised here. If u wanna me to create new thread. I will do. Pls tell me

Please Login or Register  to view this content.

Super Jeff. I loved ur explanation. Thanks a lot

Hi Jeff!
I know I marked the thread solved, but I have one final question. If wanted to wrap the text in the warning message, what modification would I need to make? Example being:

WARNING!!
Did you want to clear cells??
Did you save your work with a new file name?
Clearing Data will clear all cells!

Thanks in advance!!
J.R.

Thanks Jeff!
Your suggestion work correctly. Thanks again for all of your help with this small project.
Regards- J.R.