MsgBox Function and Arguments
 

Hi Tom,

Thank you.

Cheers
Tinä

Tom Ogilvy Wrote:
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 O
or
Cancel, my copying process is still executed. How do I get th
Cancel
Button to terminate the copying action and, how are the Butto
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


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