Sub Tester1()
ans = MsgBox(Prompt:="Go or Cancel", Buttons:=vbOKCancel)
If ans = vbCancel Then
Exit Sub
End If

MsgBox "You said OK"
' current code

End Sub

--
Regards,
Tom Ogilvy

"Tinä" wrote in message
...

Hi,

Using the Buttons Arguments: I have a 2-Button OK and Cancel Message
Box. At the moment, it makes know difference whether I click on OK or
Cancel, my copying process is still executed. How do I get the Cancel
Button to terminate the copying action and, how are the Button Return
Values used? Excel Help says that the Return Value Constants can be
used anywhere in your code but I don't understand how or when to use
them.

Thanks
Tinä


--
Tinä
------------------------------------------------------------------------
Tinä's Profile:
http://www.excelforum.com/member.php...o&userid=15410
View this thread: http://www.excelforum.com/showthread...hreadid=277703