QP School
Arrays in VBA - Printable Version

+- QP School (https://qomplainerzschool.lima-city.de)
+-- Forum: Tutorials (https://qomplainerzschool.lima-city.de/forumdisplay.php?fid=3)
+--- Forum: Excel VBA Tutorials (https://qomplainerzschool.lima-city.de/forumdisplay.php?fid=48)
+--- Thread: Arrays in VBA (/showthread.php?tid=5232)



Arrays in VBA - Qomplainerz - 07-27-2023

Description:

Arrays allow you to store multiple values of the same data type.

Example:

Sub ExampleArray()
    Dim numbers(3) As Integer
    numbers(0) = 1
    numbers(1) = 2
    numbers(2) = 3
    numbers(3) = 4

    MsgBox "The third number is: " & numbers(2)
End Sub