Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
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 | |||
function arguments | Excel Discussion (Misc queries) | |||
MIN Function with arguments | Excel Worksheet Functions | |||
If Function with 3 arguments | Excel Worksheet Functions |