Glad to hear it, but I think I actually typed it wrong, it should be

If MsgBox("Warning! Are You Sure", vbYesNo) = vbNo Then
Exit Sub
End If

because you want to exit if the user clicks "No". Also I agree with
Rick that No and Cancel basically mean the same thing, so Cancel is
unnecessary.

HTH


On Jan 24, 4:04*am, lkreeder
wrote:
Thanks, JP. Worked like a charm. Maybe I need to buy one of those thick books
to learn this stuff.....

"JP" wrote:
The code is

MsgBox "Warning! Are You Sure", vbYesNoCancel

But you'll want it to be part of a conditional statement, for example

If MsgBox("Warning! Are You Sure", vbYesNoCancel) = vbYes Then
* Exit Sub
End If