I'm using VBA in a who wants to be style millionaire game that i'm making and I would like to experiment by using a 2d array in it. I have never used one beofre so I was hoping that anyone here who knows about using 2d arrays in VBA could help me.

basically I want the array to go something like this,

1. Question 1 = 500
2. Question 2 = 1000
3. Question 3 = 2000
etc.

or

Array(1, 500)

I know that this isn't right (is it?) from what i've seen so far about 2d arrays and I was hoping that someone could help me.

Thanks.