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 |