Very Small First Program

[KthProg]

I use gotos all the time in VBA and I've never had an issue with them. They are extremely useful.
Also...jesus too many comments lol.
I'm still learning c++ at this point myself.

[centip3de]

I use gotos all the time in VBA and I've never had an issue with them. They are extremely useful.
Also...jesus too many comments lol.
I'm still learning c++ at this point myself.

Goto's are generally accepted as bad practice because they form terrible spaghetti code. Not only that, but they're usually unneeded and thus, really only form spaghetti code.

[KthProg]

Well, they're dangerous in extremely large projects, because it's difficult to see the flow of the program.
But when the code compiles down, it has to use gotos at the the assembly level, from what I know.
But it does save space sometimes. Also, in VBA, they're the only means of error catching.
It's actually very efficient to do things this way.
You use a statement like this at the beginning of a piece of code.
On Error Goto errorCatcher
then later you do this...
errorCatcher:
If Err.Number = someerrornumberofimportance or Err.Number = someotherimportanterrornumber then
Do error catching routine.
End If

this allows you to consolidate all of your error catching at the end of the program, and if the error catching fails, it will continue wherever you place the errorCatcher label. It also allows you to create a different, separate, easily readable routine for each error type. You could also use flags to tell where in the code the error is coming from, if you only want to catch it if it occurs in a certain block.

I think they should at least be used in situations like this, where you don't need error catching for a specific statement, but rather for a specific error.

[centip3de]

Well, they're dangerous in extremely large projects, because it's difficult to see the flow of the program.
But when the code compiles down, it has to use gotos at the the assembly level, from what I know.

No, ASM does not use gotos, it uses jumps. And although some similarities between the two can be drawn, they're completely different.

But it does save space sometimes. Also, in VBA, they're the only means of error catching.
It's actually very efficient to do things this way.
You use a statement like this at the beginning of a piece of code.
On Error Goto errorCatcher
then later you do this...
errorCatcher:
If Err.Number = someerrornumberofimportance or Err.Number = someotherimportanterrornumber then
Do error catching routine.
End If

this allows you to consolidate all of your error catching at the end of the program, and if the error catching fails, it will continue wherever you place the errorCatcher label. It also allows you to create a different, separate, easily readable routine for each error type. You could also use flags to tell where in the code the error is coming from, if you only want to catch it if it occurs in a certain block.

I think they should at least be used in situations like this, where you don't need error catching for a specific statement, but rather for a specific error.

I can't speak for VB, but in other languages you would do this just by calling a function, which is a much cleaner and clearer way of doing things. Not only that, but with functions, you don't get accidental calls to errors, or what-have-you. In fact, in any language (that supports them) there is no reason to use gotos versus functions.

[KthProg]

Well I dont think VB.Net supports gotos, and VB.net has try-catch-throw syntax but error catching with On Error Goto in VBA is my preferred syntax after using both, only because try catch throw is messier especially when you want to make changes to how and what errors you catch.
I don't think it should be used pretty much anywhere else, but for error catching its great.

[fashizzlepop]

I don't know much about VB but in just about Any other language, using try, catches is the preferred method.

[KthProg]

In just about any other language try catch is the only method lol.
And VB is different than VBA which is different than VB.Net
Just sayin'. lol

VBA is a subset of VB
VB.Net is a language based on VB.
VB is now deprecated (As of version 6)

VB and VBA are very similar
VB.Net is very different.