Returning from a GoTo 3

[TeresePamela]

I want to GoTo a Label and then return to the line below to GoTo - Can I do that in vba? If so, what's the command/syntax. An example:

FIRSTSUB:
Msgbox "Message One"
GoTo SubTwo
MsgBox "Message Two"


SUBTWO:
MsgBox "From Subtwo"


As always, thanks for any input.
Pam

 

[EBGreen]

You should pull whatever you do in the GOTo out into its own function.

[blue]"Well, once again my friend, we find that science is a two headed beast. One head is nice, it gives us aspirin and other modern conveniences,...but the other head of science is BAD! Oh, beware the other head of science, Arthur; it bites!!" - The Tick[/blue]

 

[SkipVought]

Hi,

You can use GoSub...

Sub MySub()
...
  GoSub MyLabel
...


  Exit Sub
MyLabel:
...
  Return
End Sub

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[TeresePamela]

Thanks guys - this forum is simply amazing. I'll test this evening.

Thanks again

 

[Zion7]

Definately an option to consider TomThumbKP!
Excellent Skip, very helpful!
Have a star!

 

[TeresePamela]

Thanks guys: It works perfectly of course