| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confirming Vlues in 2 Cells Appear in a List | Excel Worksheet Functions | |||
| how to change data in worksheet in text without confirming each s. | Excel Discussion (Misc queries) | |||
| Confirming existence of dependents | Excel Programming | |||
| Confirming existence of dependents | Excel Programming | |||
| Confirming existence of dependents | Excel Programming | |||
Threaded Mode
