9.0

188
Sub Main
Dim
X As Variant
X = 1
Debug
.Print IsNumeric(X) 'True
X = "1"
Debug.Print IsNumeric(X) 'True
X = "A"
Debug
.Print IsNumeric(X) 'False
End
Sub
IsNull Function
Syntax
IsNull(expr)
Group
Variable Info
Description
Return the True if expr is Null.
Parameter Description
expr A variant expression to test for Null.
See Also: TypeName, VarType.
Example
Sub Main
Dim
X As Variant
Debug
.Print IsEmpty(X) 'True
Debug
.Print IsNull(X) 'False
X = 1
Debug
.Print IsNull(X) 'False
X = "1"
Debug
.Print IsNull(X) 'False
X = Null
Debug
.Print IsNull(X) 'True
X = X*2
Debug
.Print IsNull(X) 'True
End
Sub
IsObject Function
Syntax
IsObject(var)
Group