Hello everybody.
Is there a similar function to goto in VBA? I would like to jump back again in the code without using an if/else condition.
Hello everybody.
Is there a similar function to goto in VBA? I would like to jump back again in the code without using an if/else condition.
Something like
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Can I jump with this codesnippet?
Example:
In this example the code would jump always back to MARK if the IF statement is executed. It is an endless loop. Just a demo what I mean with goto.Please Login or Register to view this content.
Where's the loop. Not a good example
Best way is try it and see or post some proper code with a proper example
VBA Noob
The goto jump is the loop . Take a look at http://en.wikipedia.org/wiki/GOTO.Originally Posted by VBA Noob
Nevermind, I solved the problem using a normal Do While Loop Statement.
VBA has a GoTo statement. The help system lists the syntax involved.
"Best Practice" is to use GoTo only for error handeling.
Last edited by mikerickson; 06-30-2007 at 06:14 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks