how a GoTo statement works: : GoTo « Language Basics « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Language Basics » GoTo 




how a GoTo statement works:
 
Sub GoToDemo()
    userName = InputBox("Enter Your Name: ")
    If userName <> "123" Then GoTo WrongName
    MsgBox ("Welcome Bill...")
'   ...[More code here...
    Exit Sub
WrongName:
    MsgBox "Sorry."
End Sub

 














Related examples in the same category
1.A line number is simply a number placed at the beginning of a line to identify it. For example, consider this demonstration of GoTo:
2.A GoTo statement with a condition
3.Use GoTo to do a loop
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.