Return from called Sub

[Jimmy P]

Been trying to find out how to return to the calling sub from a called sub and continue from the point right after the call statement.

_____________________________________
Public Sub Sub1()

code 1...

Call Sub2

code 2 ....

End Sub
_____________________________________
Public Sub Sub2()

Code....

What is procedure to return to Sub1 to code 2...

End Sub

 

[GTO]

After Sub2 is completed, Sub1 will continue at 'code 2...', just as you have written it; unless you have something in Sub2 that ends code execution.

Mark

 

[Jimmy P]

Thanks. Must have a bug in Sub2 to cause it not to return.

 

[NeonRedSharpie]

Thanks. Must have a bug in Sub2 to cause it not to return.

You can test this by putting a debug.print or a msgbox.

Public Sub Sub1()

'code 1...
MsgBox "CALLING SUB 2"
Call Sub2
MsgBox "RETURNING TO SUB 1"
'code 2 ....


End Sub




Public Sub Sub2()


'Code....


'What is procedure to return to Sub1 to code 2...
MsgBox "ENDING SUB 2"
End Sub

 

[Jimmy P]

Thanks. Found my bug using this.

BTW How did you get the screenshot of the code window?

 

[GTO]

You can use Code tags.

[code=rich]
'Your code between the code tags...
[/code]

Notice the solidus (slash) in the closing tag.