on error goto

[c@lle]

what's the difference between

on error goto ErrH:

and

on error goto ErrH

[vbgladiator]

I believe on Error goto ErrH: is a label

on error goto Errh is a statement.

[Joacim Andersson]

None!
A label that you jump to must look like this.
LabelName:
With the colon but at the goto part the colon can be omitted.

[Hack]

Both are supported, and both will work.

The colon typically, however, denotes a label to which the sub or function should branch.

[Joacim Andersson]

Originally posted by vbgladiator
I believe on Error goto ErrH: is a label

on error goto Errh is a statement.

On Error Goto is a statement and with goto you have to name the label. But the colon is only necassary to define the actual label.

[vbgladiator]

So this is legal?

On error goto ErrHandler:


ErrHandler:

[Hack]

I ran a test before posting, because I wasn't sure if using a colon in the On Error would work, but it does. Run this in a test project

Private Sub Command1_Click()
    On Error GoTo errh
    Dim i As Integer
    i = 1 / 0    
errh:
   MsgBox "Division by zero"
End Sub

You will get the Division by zero message box. Now run this

Private Sub Command1_Click()
    On Error GoTo errh:
    Dim i As Integer
    i = 1 / 0    
errh:
   MsgBox "Division by zero"
End Sub

Once again, you will get the Division by zero message box.

[plenderj]

If you want to string multiple lines of code together into one long line of code you can use the full colon to put them together.
So I suppose you could probably stick a colon after anything and it would work the same

[Joacim Andersson]

Well actually Hack you'll get that message box even if you remove the division statement... You'll always need to exit the sub or function before the Label so the statements in the error handler is only executed if an error has occured.

[Joacim Andersson]

Originally posted by plenderj
If you want to string multiple lines of code together into one long line of code you can use the full colon to put them together.
So I suppose you could probably stick a colon after anything and it would work the same

That's true. But the actual definition of the Label must be followed by a colon. That also proves that you can't use a keyword or a function name as a label.