VBA Functions: Tests and Conditions
Find the list of all the main VBA functions on the VBA Functions page.
Tests and Conditions
IIf | Returns one of the 2 values passed as an argument depending on a condition. |
IsArray | Returns True if the variable points to an array or False if it does not. |
IsDate | Returns True if the value is a date (or can be converted to a date) or False if it is not. |
IsEmpty | Returns False if the variable has been initialized or True if it has not. |
IsMissing | Returns False if the optional argument has been filled in or True if it has not. |
IsNumeric | Returns True if the value can be considered a number or False if it can not. |
Switch | Returns the value corresponding to the first expression that returns True. |
VarType | Returns an integer corresponding to the type of the variable. |