MS-Excel / General Formatting

Miscellaneous Functions

FunctionWhat 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.
DoEventsYields 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.
[Previous] [Contents] [Next]