Function | What It Returns |
Array(arglist) | A Variant array containing the values in arglist. |
CallByName(object,procname, etc.) | The value of the procname property of the specified object. Also can run the object's procname method. |
Choose(index, choice1, etc.) | A value from a list of choices. |
CreateObject(class) | An Automation object of type class. |
DoEvents | Yields execution to the operating system so that it can process pending events from other applications (such as keystrokes and mouse clicks). |
Environ(envstring|number) | A String value that represents the operating system environment variable given by envstring or number. |
Format(expression, format) | The expression, as a Variant, according to the string format. |
Format$(expression, format) | The expression, as a String, according to the string format. |
FormatCurrency(Expression, etc.) | Expression formatted as a currency value. |
FormatDateTime(Date, NamedFormat) | Date formatted as a date or time value. |
FormatNumber(Expression, etc.) | Expression formatted as a numeric value. |
FormatPercent(Expression, etc.) | Expression formatted as a percentage value. |
GetAllSettings(appname, section) | All the settings in the specified section of the Registry. |
GetObject(pathname, class) | The Automation object given by pathname and class. |
GetSetting(appname, etc.) | A setting from the Registry. |
IIf(expr, truepart, falsepart) | The truepart value if expr is True; returns falsepart otherwise. |
Input(number, #filenumber) | number characters, as a Variant, from the I/O file given by filenumber. |
Input$(number, #filenumber) | number characters, as a String, from the I/O file given by filenumber. |
InputB(number, #filenumber) | number bytes, as a Variant, from the I/O file given by filenumber. |
InputB$(number, #filenumber) | number bytes, as a String, from the I/O file given by filenumber. |
InputBox(prompt, etc.) | Prompts the user for information. |
IsArray(varname) | True if varname is an array. |
IsDate(expression) | True if expression can be converted into a date. |
IsEmpty(expression) | True if expression is empty. |
IsError(expression) | True if expression is an error. |
IsMissing(argname) | True if the argument specified by argname was not passed to the procedure. |
IsNull(expression) | True if expression is the null string (""). |
IsNumeric(expression) | True if expression is a number. |
IsObject(expression) | True if expression is an object. |
LBound(arrayname, dimension) | The lowest possible subscript for the array given by arrayname. |
MsgBox(prompt, etc.) | The button a user selects from the MsgBox dialog box. |
Partition(number, start, stop,...) | A String that indicates where number occurs within a series of ranges. |
QBColor(color) | The RGB color code that corresponds to color (a number between 1 and 15). |
RGB(red, green, blue) | The color that corresponds to the red, green, and blue components. |
Switch(expr1, value1, etc.) | Evaluates the expressions (expr1 and so on) and returns the associated value (value1 and so on) for the first expression that evaluates to True. |
Tab(n) | Positions output for the Print # statement or the Print method. |
TypeName(varname) | A string that indicates the data type of the varname variable. |
UBound(arrayname, dimension) | The highest possible subscript for the array given by arrayname. |
VarType(varname) | A constant that indicates the data type of the varname variable. |