“GoTo” is a way of quickly rerouting the flow of your code say to an earlier point. When we discussed GoTo statements we showed you how to:

  • Create a location for the GoTo statement. In the GoTo example we used the code EnterMoneyIn: but you could name the location as you see fit. The key is the colon “:” at the end.
  • The next line of code we used (rerouting the program) was GoTo EnterMoneyIn.

That’s all there is to it. Two lines of code create your GoTo statement.

Macros coverage from the financial modelling course

You’re looking at the macros glossary from our course material covering the use of macros in Excel financial modelling.

...join the conversation...

Your email address will not be published. Required fields are marked *