Page 4 - VBA Reference card © Soren Lauesen 2007 VBA ...
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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- tutorial 6943 excel add in functions for pmbus number formats
- page 4 vba reference card © soren lauesen 2007 vba
- binary conversion practice convert these binary
- conversion of binary octal and hexadecimal numbers
- 1 converting floating point numbers from the hexadecimal
- runtime library libreoffice
- decimal binary and hexadecimal
- vba functions
- aes example input 128 bit key and message
- excel decimal to hex
Related searches
- excel vba quick reference pdf
- excel vba reference library
- excel vba language reference pdf
- excel vba reference guide
- microsoft vba reference manual pdf
- vba reference column by number
- vba language reference guide pdf
- access vba reference guide
- vba language reference guide
- excel vba language reference guide
- python quick reference card pdf
- vba reference pdf