Macro for Confirming Delete
you're welcome
"COG" wrote in message
...
Thank you for your help!
-----Original Message-----
Hi Cog
a message box will do what you're after
e.g.
sub yourexistingcode()
dim i as long
i = msgbox("Are you sure?",vbyesno,"Be very, very
sure!")
if i = vbno then
msgbox "No data is to be
deleted!",vbOkOnly,"Don't Delete Data"
'this is optional, just put here as an example
exit sub
end if
---your delete code here
end sub
Cheers
JulieD
"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?
.
|