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. |