exit parent functions as well

[Shridevi.Salagare]

Is there any way we can exit the parent function as well.
E.g
Function F1
call F2
.....
.....
End Function

So if during execution of function F2 it fails and i want to exit function F2 as well as F1..Can we do that using code?

[basanth27]

How about using "Exit Function" if the condition fails?

[Shridevi.Salagare]

Exit function would exit only current Function .I want to exit Its parent function as well.

[Ankur]

Assign some unique value just before you wish to Exit the first function. Check for that return value using a conditional statement and Exit if that matches. You can extend this logic to any number of nested function calls, just need to have a unique return key

Code:

Function Ex1()    
    Ex1 = 0
    Exit Function
End Function

Function Ex2()
    Ret = Ex1()
    If Ret = 0 Then
    msgbox Ret
    'Exit Function    
    End If
End Function

Call Ex2()

Hope that helps!