PDA

Click to See Complete Forum and Search --> : 2d arrays


Shmokin
Feb 16th, 2006, 05:48 AM
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.

Ecniv
Feb 16th, 2006, 06:14 AM
dim aryMonies() as long

redim aryMonies(15)
aryMonies(0)=500
aryMonies(1)=1000
'etc..
'16th entry \/
aryMonies(15)=1000000