Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
End Double Sub
Yes I know, but do you have a sollution for my problem? With the *En Sub*, I end the sub I'm working with, *not the Sub that is referring t this sub*. (see code a few messages above) Zur -- Zur ----------------------------------------------------------------------- Zurn's Profile: http://www.excelforum.com/member.php...fo&userid=1464 View this thread: http://www.excelforum.com/showthread.php?threadid=26724 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
End Double Sub
Turn the sub into a function and return a boolean (true or false).
The calling procedure exits depending on the value of the returned value. eg. Sub Proc() If Func() = False Then MsgBox "Arrgh" Exit Sub End If MsgBox "Made it!" End Sub Function Func() As Boolean If MsgBox("Click Me", vbOKCancel) = vbOK Then Func = True Else Func = False End If End Function -- Rob van Gelder - http://www.vangelder.co.nz/excel "Zurn" wrote in message ... Yes I know, but do you have a sollution for my problem? With the *End Sub*, I end the sub I'm working with, *not the Sub that is referring to this sub*. (see code a few messages above) Zurn -- Zurn ------------------------------------------------------------------------ Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645 View this thread: http://www.excelforum.com/showthread...hreadid=267249 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
Double IF - is this possible | Excel Worksheet Functions | |||
End Double Sub | Excel Programming | |||
End Double Sub | Excel Programming | |||
End Double Sub | Excel Programming |