Category |
Keywords |
Array handling |
Dim,
ReDim
IsArray
Erase
LBound,
UBound |
Assignments |
=
Set |
Comments |
Rem |
Constants/Literals |
Empty
Nothing
Null
True,
False
|
Control flow |
Do...Loop
For...Next
If...Then...Else
Select Case
While...Wend |
Conversions |
Abs
Asc, AscB, AscW
Chr, ChrB, ChrW
CBool,
CByte
CDate,
CDbl,
CInt
CLng,
CSng,
CStr
DateSerial,
DateValue
Hex,
Oct
Fix,
Int
Sgn
TimeSerial,
TimeValue |
Dates/Times |
Date,
Time
DateSerial,
DateValue
Day,
Month,
Weekday,
Year
Hour,
Minute,
Second
Now
TimeSerial,
TimeValue |
Declarations |
Dim,
ReDim
Function,
Sub |
Error Handling |
On Error
Err |
Input/Output |
InputBox
MsgBox |
Math |
Atn,
Cos,
Sin,
Tan
Exp,
Log,
Sqr
Randomize,
Rnd |
Operators |
Addition (+),
Subtraction (-)
Exponentiation (^)
Modulus arithmetic (Mod)
Multiplication (*),
Division (/),
Integer Division (\)
Negation (-)
String concatenation (&)
Equality (=),
Inequality (<>)
Less Than (<),
Less Than or Equal To (<=) Greater Than (>),
Greater Than or Equal To (>=)
Is
And,
Or,
Xor
Eqv,
Imp
|
Objects |
CreateObject
IsObject |
Options |
Option Explicit |
Procedures |
Call
Function,
Sub
|
Strings |
Asc,
AscB,
AscW
Chr,
ChrB,
ChrW
Instr,
InStrB
Len,
LenB
LCase,
UCase
Left,
LeftB
Mid,
MidB
Right,
RightB
Space
StrComp
String
LTrim,
RTrim,
Trim |
Variants |
IsArray
IsDate
IsEmpty
IsNull
IsNumeric
IsObject
VarType |