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