VBA Functions: Tests and Conditions

Find the list of all the main VBA functions on the VBA Functions page.

Tests and Conditions

IIfReturns one of the 2 values passed as an argument depending on a condition.
IsArrayReturns True if the variable points to an array or False if it does not.
IsDateReturns True if the value is a date (or can be converted to a date) or False if it is not.
IsEmptyReturns False if the variable has been initialized or True if it has not.
IsMissingReturns False if the optional argument has been filled in or True if it has not.
IsNumericReturns True if the value can be considered a number or False if it can not.
SwitchReturns the value corresponding to the first expression that returns True.
VarTypeReturns an integer corresponding to the type of the variable.