A.12. Information Functions

Err Function

Returns the error code of the last error

IMEStatus Function

Returns the system's current IME mode

IsArray Function

Returns True if a variable is an array

IsDate Function

Returns True if an expression can be converted to a date

IsEmpty Function

Returns True if a variant variable has not been initialized

IsError Function

Returns True if an expression is an error value

IsMissing Function

Returns True if an optional parameter has not been passed

IsNull Function

Returns True if an expression evaluates to Null

IsNumeric Function

Returns True if an expression can be evaluated as a number

IsObject Function

Returns True if a variable contains an object reference

QBColor Function

Returns the RGB color code for a specified color number

RGB Function

Returns a number representing an RGB color value

TypeName Function

Returns the data subtype name of a variant variable

VarType Function

Returns a number representing the data subtype of a variant variable

Get VB & VBA in a Nutshell: The Language now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.