msgbox when deleting cells

Mikedk64 · #6 07-12-2017, 08:12 AM

*Logit:

Where should I insert this code, and can i just copy paste it, or do I need to modify it

Quote:

Originally Posted by Logit

Code:

Option Explicit

Sub Test3()
Dim answer As Variant
  answer = MsgBox("Are you certain these cells are to be deleted ?", vbYesNo + vbQuestion, "Delete Cells ?")
  If answer = vbYes Then
      Call Test1
   Else
     Exit Sub
End If
End Sub

Sub Test1()
   'Code here to delete or clear cells
   MsgBox "Running macro"
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trigger Beep or MsgBox when key combo accidentally pressed	NotQuiteANovice	Word VBA	1	04-07-2017 05:41 PM
Deleting rows based on the text in certain cells VBA	ThisGuyJohn	Excel Programming	5	02-03-2017 03:16 PM
On Open MsgBox for use in Template sent out to colleagues to gather information	Lancashire Lad	Word VBA	2	10-26-2015 10:22 AM
Deleting info from specific table cells	jamierbooth	Word VBA	3	07-29-2014 03:20 PM
Make MsgBox appear...	Jamtart	PowerPoint	3	09-01-2012 08:21 AM