what happens to code after call method in Sub?

[dantheman9]

Hi,

Im running a sub which then calls another Sub, does vba return to that point in the first sub after running the second Sub? (I'm looking to set a variable from the second sub code for use in the first).


thanks

 

[hutchisd]

Hi,

Im running a sub which then calls another Sub, does vba return to that point in the first sub after running the second Sub? (I'm looking to set a variable from the second sub code for use in the first).


thanks

Yes it returns to sub1 after sub2 runs through completely. If you want to use a variable in multiple subs I would use a global variable that you would put outside of all subs. For example,

Global x as long

Sub1()
Call Sub2()
End Sub

Sub2()
blah blah
End Sub

 

[shg]

Yes. Except for error handling, all procedures return to the line following the invocation (e.g., the Call statement) in the calling routine.

 

[dantheman9]

thanks to both of you!!

 

[Rasm]

Yes- as you say - here it passes a variable abc set in seconsub back to firstsub. Being it is Private sub - it does not show on macro list.

Option Explicit
Public Sub Firstsub()
    Dim abc As Single
    Call SecondSub(abc)
End Sub
Private Sub SecondSub(abc)
    abc = 4
End Sub