Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - How do you do an array?
vba courses london - How do you do an array?
Resolved · Low Priority · Version Standard
For upcoming training course dates see: Pricing & availability
RE: How do you do an array?
Hi TobyTo create an array in VBA, you need a statement such as:
Dim myArray(1 To 8) As Integer
This will create an array of Integers using the values provided in this case 1 to 8.
an alternate is
Dim myArray As Variant
myArray = Array(1, 2, 3, 84 5)
There are many other types of array, i.e. an array of strings that you should look into.
Hope this helps
David
|
|
» Forum post: Inserting video clips & pictures from internet to powerpoint |



Course updates

