Using the Array Function : Array Function « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. Array Function

Using the Array Function

 
Sub CarInfo()
    Dim auto As Variant

    auto = Array("Ford", "Black", "1999")
    MsgBox auto(2) & " " & auto(1) & ", " & auto(3)

    auto(2) = "4-door"
    MsgBox auto(2) & " " & auto(1) & ", " & auto(3)
End Sub








Related examples in the same category

1.The LBound and UBound functions return whole numbers that indicate the lower bound and upper bound indices of an array.
2.avoids the error "Subscript out of range"
3.Use IsArray function to check if a variable is an array