Search notes:
VBA: datatype variant
The
actual
datatype of a variant variable is determined at runtime. Hence the name.
empty / null
There are two variant
literal identifiers
:
empty
and
null
.
As long as a variant variable is unitizlied, it is said to be
empty
.
isEmpty()
can be used to determine if a variant was initialized.
A variant (as opposed to all other
VBA data types
) can be set to
null
to specificilly indicate the absence of any value or invalid data.
If the «value» of a variant is
empty
or
null
can be tested with the
isEmpty()
and
isNull()
function.
See also
datatypes
C definition of a VARIANT
The
SQL Server data type
sql-variant
.
Index