try help under msgbox

that should get you in the right direction

"COG" wrote in message
...
Hi all, I can create a button with a macro that will
clear the data in a preselected range - using the macro
recorder. However, when the button is clicked, I would
like a message to appear that says, "Are You Sure" and
have a "Yes" button, and a "No" button for the user to
click on - to verify clear the range or return to what
they were doing. I think this is a macro inside a macro
and I am not sure how to do this. Any HELP you can offer
would be appreciated. Ex - when you start to close an
Excel file you've entered data into, and haven't saved
it, a message will appear asking if you really want to
save changes. How can I create such a message with
options yes and no?