Reading/Writing to Arrays
You can fill elements of an array very
easily. You can use the following syntax:
ArrayName(Element) = Value
Where element is a valid element. The
following code declares gArray and fills elements 1,2 and 3 with names.
Dim sArray(1 To 10) As String
sArray(1) = "Paul"
sArray(2) = "Fred"
sArray(3) = "Colin"
Likewise, you can access the value in the array in the same way. The following
code displays a message box containing the 3rd value in sArray:
Msgbox sArray(3)
As I said at the start of this tutorial, this can be very beneficial as you
can access different values in the array using code. For example, if you hard
coded 3 variables:
Dim sName1 As String
Dim sName2 As String
Dim sName3 As String
you would be limited to 3 names, and if you wanted to access them, you would
have to write different code for accessing each variable, as you can't type
Msgbox (sName & lNum)
to access sName1, if lNum is 1. With Arrays, you can:
Msgbox sNames(lNum)