Goto

Syntax

Goto Label

Remarks

Redirects a running macro from the Goto instruction to the specified Label anywhere in the same subroutine or function. The macro continues running from the instruction that follows the label. Keep the following in mind when placing a label in a macro:

• Labels must be the first text on a line and cannot be preceded by spaces or tab characters.
• Labels must be followed by a colon (:). (Do not include the colon in the Goto instruction.)
• Labels that contain letters must begin with a letter and can contain letters and numbers up to a maximum length of 40 characters, not counting the colon.
• You can use a number that appears at the beginning of a line instead of a label. Line numbers are supported primarily for compatibility with Basic programs created in older versions of the Basic programming language that required line numbers. The line number can be as high as 32,759 and does not need a colon following it.

Example

This macro displays a message box, with Yes, No, and Cancel buttons, asking if the user wants to continue the macro. If the user chooses No or Cancel, the macro branches to the label bye immediately before End Sub, and the macro ends.

Sub MAIN
ans = MsgBox("Continue macro?", 3)
If ans = 0 Or ans = 1 Then Goto bye
'Series of instructions to run if the user chooses Yes
bye:
End Sub

See Also

For¼Next, If¼Then¼Else, Select Case, While¼Wend