MsgBox Function and Arguments
 

Hi,

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

Thanks
Tin

--
Tin
-----------------------------------------------------------------------
Tinä's Profile: http://www.excelforum.com/member.php...fo&userid=1541
View this thread: http://www.excelforum.com/showthread.php?threadid=27770

MsgBox Function and Arguments
 

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