Local arrays are a way of storing data in Excel. In this video, we will look at two different ways that you can place data inside an array in Excel VBA. The first method is used when the developer wants to hardcode it themselves. The second approach allows the user to enter the data.