Having some trouble bulk assigning values to an array. I know that you can assign values to an array individually, but what I would really like is to assign all values in one statement like in other programming languages.

Here is my code. Any assistance would be greatly appreciated.

[vba]
Dim aArray(3) As Integer
Dim index As Integer
aArray = {1, 2, 3}

For index = LBound(aArray) To UBound(aArray)
MsgBox aArray(index)
Next
[/vba]

btw. this is my first post and i'm not a 100 percent sure if i'm in the right section. sorry if i'm not....