Yes or no confimation before macro runs.

[Subtotalatom]

I have this formula (Kindly edited by Logit).

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 10 Then
If Target.Value = "Invoice Complete" Then
'Turn off events to prevent recursive calls
Application.EnableEvents = False
'Copy row to new worksheet
Target.EntireRow.Copy
With Worksheets("Complete")
.Range("A" & .Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteAll
End With
'Delete the source row
Target.EntireRow.Delete
'Turn events back on
Application.EnableEvents = True
End If
End If
End Sub

however i need the spreadsheet to prompt the user to confirm with a yes or no box before it runs. because if the user changes the cell by accident the macro will run said script meaning potential mistakes.

i have attached the spreadsheet to show what the spreadsheet will do - if you change the J column cells to Invoice complete it will run the script

[Logit]

.
You can use this example as a template. Change the wording to fit ...

Please Login or Register  to view this content.

[Subtotalatom]

Hi Logit,

I cannot seem to get this to work with my original code.

[Logit]

.
Try this version :

Please Login or Register  to view this content.

[Subtotalatom]

Again thank you.

[Logit]

.
You are welcome.

[Subtotalatom]

Hi Logit,

spreadsheet works which is great (Massive help), however one of the users has pointed out that when they select no on the yesno prompt after changing the cell to invoice complete, it stops the macro but it is leaving the Invoice complete in the cell as text. is there away to get the code to leave this blank? so that they have select it from the dropdown box again?