Page 4 - VBA Reference card © Soren Lauesen 2007 …

[Pages:2]Page 4 - VBA Reference card

Line continuation, comments, assignment i = i+2 ` Comment s = "long text A" & _

"long text B" ` Comment in last line only

Set f = Forms(0)

Store a reference

Set f = New Form_frmG Create object, store ref

Set f = Nothing

Delete object if last ref

Conditional statements

If a=1 Then c=d+2

Single statement

If a=1 Then c=d+2 . . .

ElseIf a=2 Then c=d / 2 . . .

Else c=0 . . .

End If

Multiple statements Optional Optional

Select Case zip

Case 4000

type = a . . .

Case 4001, 5000 To 5999

type = b . . .

Case Else

type = c . . .

Optional

End Select

On Error Resume Next Ignore error . . . If Err > 0 Then . . . Test for error

On Error GoTo fail . . .

fail: MsgBox( . . . )

Enable error handler Continue here at error

On Error GoTo 0

Let VBA handle errors

While a ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download