Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Has Too Many Arguments | Excel Worksheet Functions | |||
Sum function changes arguments | Excel Worksheet Functions | |||
MIN Function with arguments | Excel Worksheet Functions | |||
Is it possible to use more than 8 arguments in a function? | Excel Discussion (Misc queries) | |||
MsgBox Function and Arguments | Excel Programming |