The VBA language provides a universal (or
vague) data type you can use for any type of value. The Variant data
type is used to declare a variable whose type is not explicitly
specified. This means that a Variant data type can hold any type of
value you want.
Here are examples of Variant-declared variables
that hold different types of values:
Dim FullName As Variant
Dim EmploymentStatus As Variant
Dim HourlySalary As Variant
Dim DateHired As Variant
FullName = "Patricia Katts"
EmploymentStatus = 2
HourlySalary = 35.65
DateHired = #6/22/2004#