QP School

Full Version: Arrays in VBA
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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