silly question for goto statements

[Luis939]

this might seem as a silly question, but i dont want to write too many lines of code, is there any way of say declaring a variable and then using a goto statement with that variable, however the label it refers to doesnt have the same name, such as this:

myvariable = "International"
GoTo myvariable
.
.
International:
.
.
Obviously if I leave it like that, i'll get a big error, but i just dont want to write a bunch of If-statments. Thanks

 

[Zathras]

Use GOTO only as a last resort. Take a look at the CASE statement. It is probably what you need in this situation.

 

[bryanbayfield]

GoTo is usually just used for error trapping.

As Zathras says,

Select Case

should be used as a switching statement, which avoids the need for nested

If ... Then

blocks.

 

[Luis939]

yea i'll have to do that to clear up this code, thanks!

 

[Luis939]

Ok i know i should use case statments, but with the goto statement, could i be able to have a label that is not in the same sub and "goto" that label, currently i get an error because the label, or destination must be in the same sub as the goto statement, i probably wont end up using these goto statements, but i'm still curious and would like to learn as much VBA as possible (if you haven't been able to tell already lol)

 

[Zathras]

It's not VBA that is the problem, it's understanding how subs and functions work in any programming language.

Even if you could find a programming language that permitted a GOTO to some label outside of the current subroutine, I would not use it.

I can't even imagine a situation where it would be necessary. There is a theoretical construct which Larry Constantine wrote about back in the 70's that he called co-routines which comes close, but I've never found a practical application.

I strongly suggest you re-examine the structure of the application you are attempting to build.

I am curious, though. Why do you think you want to GOTO a label outside of the current routine? If you plan to come back, just CALL the other sub. If not, just EXIT the current sub.

 

[Luis939]

Yea well I've always heard about not using goto, its just that in my programming, being such a novice programmer, i don't expand or broaden my practical knowledge of programming, and I rely on basic elementary methods to accomplish whatever tasks I need, but thanks for all your help, the code you've provided in my threads has been extrememly invaluable to me (and saved my job ). Thanks Zathras

 

[Cresby]

using calls might look more wordy and tedious but think of the tedium (no it is exciting tearing your hair out) debugging spaghetti.

Trust me, those who self taught on GW &/or QB2.5 (etc) know where you're at and it is in the middle of a very busy highway. Jump out now!

 

[Luis939]

I'm OUT!