VBA Excel how to get back to the code after using the GoTo statement? 1

[knifey]

Hi,
This may sound like a very simple question. But does anyone know how to get back to the point where you were after completing a GoTo statement (In REXX it is call, then return after the call is complete).
Any advice would be much apprecuiated.
Thanks,
Knifey.

 

[Bong]

I suggest you use GoSub and Return. Go To is almost never necessary and is pretty universally frowned on in programming communities. If you insist, you'd have to set a Go To again in the gone to code to get back to where you started.

_________________
Bob Rashkin

 

[Andrzejek]

Simple, don't use GoTo (except for error handling)

Use Call:

Line1
Call MySub
Line2

Private Sub MySub()

End Sub

So after Call MySub you will get back to Line2 of your code. Automagically


Have fun.

---- Andy

 

[SkipVought]

Hi,

Results in, what is referred to as, spaghetti code.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[knifey]

Thanks everyone,
This works like a dream.
Skip, I know this creates spaghetti code but I have around 15 different scenarios that point to the same code. So it was either this or replicate the code 15 times.
Cheers,
Roy

 

[SkipVought]

Well designed GoSub/Return, is not spaghetti code.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[knifey]

Thanks for the help everyone,
I went with the gosub and return which has worked out perfectly (thanks Bob).
Cheers,
Roy