Microsoft Office Forums - View Single Post

Mikedk64 · 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