A Variant allows VBA to make its own decision as to what type of data it is holding : Variant « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. Variant

A Variant allows VBA to make its own decision as to what type of data it is holding

 
Sub varSun()
    Dim varMyData As Variant
    varMyData = "This is a Variant"
    Debug.Print varMyData
    varMyData = 12
    Debug.Print varMyData
End Sub








Related examples in the same category

1.If you simply declare a variable with a Dim statement and leave off the type-declaration keyword or character, the variable is a variant
2.Variant string
3.Get the variable type for Variant
4.One of the few instances in which you have no choice for using a Variant:
5.A Variant allows VBA to make its own decision as to what type of data it is holding: string and integer
6.Assign difference type variable to Variant variable
7.Add Variant integer to Variant string
8.Add Variant string to Variant integer
9.Add Variant integer in string to another Variant integer in string
10.Determining the Type of a Variant