Language Element

Description 
Abs Function 
Returns the absolute value of a number. 
Array Function 
Returns a Variant containing an array. 
Asc Function 
Returns the ANSI character code corresponding to the first
letter in a string. 
Atn Function 
Returns the arctangent of a number. 
CBool Function 
Returns an expression that has been converted to a Variant
of subtype Boolean. 
CByte Function 
Returns an expression that has been converted to a Variant
of subtype Byte. 
CCur Function 
Returns an expression that has been converted to a Variant
of subtype Currency. 
CDate Function 
Returns an expression that has been converted to a Variant
of subtype Date. 
CDbl Function 
Returns an expression that has been converted to a Variant
of subtype Double. 
Chr Function 
Returns the character associated with the specified ANSI
character code. 
CInt Function 
Returns an expression that has been converted to a Variant
of subtype Integer. 
CLng Function 
Returns an expression that has been converted to a Variant
of subtype Long. 
Cos Function 
Returns the cosine of an angle. 
CreateObject
Function 
Creates and returns a reference to an Automation object. 
CSng Function 
Returns an expression that has been converted to a Variant
of subtype Single. 
CStr Function 
Returns an expression that has been converted to a Variant
of subtype String. 
Date Function 
Returns the current system date. 
DateAdd Function 
Returns a date to which a specified time interval has been
added. 
DateDiff Function 
Returns the number of intervals between two dates. 
DatePart Function 
Returns the specified part of a given date. 
DateSerial Function 
Returns a Variant of subtype Date for a
specified year, month, and day. 
DateValue Function 
Returns a Variant of subtype Date. 
Day Function 
Returns a whole number between 1 and 31, inclusive,
representing the day of the month. 
Eval Function 
Evaluates an expression and returns the result. 
Exp Function 
Returns e (the base of natural logarithms) raised to
a power. 
Filter Function 
Returns a zerobased array containing subset of a string
array based on a specified filter criteria. 
Fix Function 
Returns the integer portion of a number. 
FormatCurrency
Function 
Returns an expression formatted as a currency value using
the currency symbol defined in the system control panel. 
FormatDateTime
Function 
Returns an expression formatted as a date or time. 
FormatNumber
Function 
Returns an expression formatted as a number. 
FormatPercent
Function 
Returns an expression formatted as a percentage (multiplied
by 100) with a trailing % character. 
GetLocale Function 
Returns the current locale ID value. 
GetObject Function 
Returns a reference to an Automation object from a file. 
GetRef Function 
Returns a reference to a procedure that can be bound to an
event. 
Hex Function 
Returns a string representing the hexadecimal value of a
number. 
Hour Function 
Returns a whole number between 0 and 23, inclusive,
representing the hour of the day. 
InputBox Function 
Displays a prompt in a dialog box, waits for the user to
input text or click a button, and returns the contents of the
text box. 
InStr Function 
Returns the position of the first occurrence of one string
within another. 
InStrRev Function 
Returns the position of an occurrence of one string within
another, from the end of string. 
Int Function 
Returns the integer portion of a number. 
IsArray Function 
Returns a Boolean value indicating whether a variable
is an array. 
IsDate Function 
Returns a Boolean value indicating whether an
expression can be converted to a date. 
IsEmpty Function 
Returns a Boolean value indicating whether a variable
has been initialized. 
IsNull Function 
Returns a Boolean value that indicates whether an
expression contains no valid data (Null). 
IsNumeric Function 
Returns a Boolean value indicating whether an
expression can be evaluated as a number. 
IsObject Function 
Returns a Boolean value indicating whether an
expression references a valid Automation object. 
Join Function 
Returns a string created by joining a number of substrings
contained in an array. 
LBound Function 
Returns the smallest available subscript for the indicated
dimension of an array. 
LCase Function 
Returns a string that has been converted to lowercase. 
Left Function 
Returns a specified number of characters from the left side
of a string. 
Len Function 
Returns the number of characters in a string or the number
of bytes required to store a variable. 
LoadPicture Function 
Returns a picture object. Available only on 32bit
platforms. 
Log Function 
Returns the natural logarithm of a number. 
LTrim Function 
Returns a copy of a string without leading spaces. 
Mid Function 
Returns a specified number of characters from a string. 
Minute Function 
Returns a whole number between 0 and 59, inclusive,
representing the minute of the hour. 
Month Function 
Returns a whole number between 1 and 12, inclusive,
representing the month of the year. 
MonthName Function 
Returns a string indicating the specified month. 
MsgBox Function 
Displays a message in a dialog box, waits for the user to
click a button, and returns a value indicating which button
the user clicked. 
Now Function 
Returns the current date and time according to the setting
of your computer's system date and time. 
Oct Function 
Returns a string representing the octal value of a number. 
Replace Function 
Returns a string in which a specified substring has been
replaced with another substring a specified number of times. 
RGB Function 
Returns a whole number representing an RGB color value. 
Right Function 
Returns a specified number of characters from the right side
of a string. 
Rnd Function 
Returns a random number. 
Round Function 
Returns a number rounded to a specified number of decimal
places. 
RTrim Function 
Returns a copy of a string without trailing spaces. 
ScriptEngine
Function 
Returns a string representing the scripting language in use. 
ScriptEngineBuildVersion
Function 
Returns the build version number of the scripting engine in
use. 
ScriptEngineMajorVersion
Function 
Returns the major version number of the scripting engine in
use. 
ScriptEngineMinorVersion
Function 
Returns the minor version number of the scripting engine in
use. 
Second Function 
Returns a whole number between 0 and 59, inclusive,
representing the second of the minute. 
SetLocale Function 
Sets the global locale and returns the previous locale. 
Sgn Function 
Returns an integer indicating the sign of a number. 
Sin Function 
Returns the sine of an angle. 
Space Function 
Returns a string consisting of the specified number of
spaces. 
Split Function 
Returns a zerobased, onedimensional array containing a
specified number of substrings. 
Sqr Function 
Returns the square root of a number. 
StrComp Function 
Returns a value indicating the result of a string
comparison. 
String Function 
Returns a repeating character string of the length
specified. 
StrReverse Function 
Returns a string in which the character order of a specified
string is reversed. 
Tan Function 
Returns the tangent of an angle. 
Time Function 
Returns a Variant of subtype Date indicating the current
system time. 
Timer Function 
Returns the number of seconds that have elapsed since 12:00
AM (midnight). 
TimeSerial Function 
Returns a Variant of subtype Date containing
the time for a specific hour, minute, and second. 
TimeValue Function 
Returns a Variant of subtype Date containing
the time. 
Trim Function 
Returns a copy of a string without leading or trailing
spaces. 
TypeName Function 
Returns a string that provides Variant subtype
information about a variable. 
UBound Function 
Returns the largest available subscript for the indicated
dimension of an array. 
UCase Function 
Returns a string that has been converted to uppercase. 
VarType Function 
Returns a value indicating the subtype of a variable. 
Weekday Function 
Returns a whole number representing the day of the week. 
WeekdayName Function 
Returns a string indicating the specified day of the week. 
Year Function 
Returns a whole number representing the year. 