Populating 2d arrays [resolved]

[mr_metal_hed]

I know that I can populate a 1d array like this:

Dim Ax1()
Cat = Array("q", "w", "e", "r", "t", "y", "u", "i", "o")

Is there a similar way to populate an array of 2d or more? There must be a better way than this:

Dim Ax2(2, 2)
Ax2(0, 0) = "q": Ax2(0, 1) = "w": Ax2(0, 2) = "e"
Ax2(1, 0) = "r": Ax2(1, 1) = "t": Ax2(1, 2) = "y"
Ax2(2, 0) = "u": Ax2(2, 1) = "i": Ax2(2, 2) = "o"

[chemicalNova]

Because each time you are assigning a value to the 2d array, there is no way to loop through and apply values. This is the sort of thing that is used outside of loops.



Phreak

[mr_metal_hed]

I don't understand what you said, but I'll take it as a 'no'.

[mr_metal_hed]

It seems to me that something like this should work:

Ax2 = Array(("q", "w", "e"), ("r", "t, "y"), ("u", "i", "o"))

Since I have no other replies, I assume that there is not way to populate a 2d array by listing arguments. Is there another way to store the same data? An array of arrays maybe? I have not dealt with arrays within arrays and I'm not sure how to go about it, or their similarity with multidimensional arrays.

Input, ideas, or examples?

[Arc]

Not sure this is exactly what you are looking for, but you can loop through an multi-dementional array and add values.

Dim MyArray(10, 10) As String
 
For i = 0 To 10
 For j = 0 To 10
   MyArray(i, j) = "Num" & i + j
 Next
Next
MsgBox MyArray(7, 9)

[mr_metal_hed]

That won't work because my array values aren't sequential. I can't just use an increment to assign them. The array values are constant. I use them for comparison to evaluate input.

Thanks anyway!

[SLH]

You could just use a 1D array, and have functions to access it as if it was a 2D array.

[mr_metal_hed]

You are right. I could use an increment and the Mid() function to loop through each position in the data within each array item to make it act like a 2d array. But if I wanted to do that, I wouldn't bother using arrays at all. I could just use one long string, taking data from the necessary position as needed.

Right now, the 2d array is working out fine. I just don't like that there isn't an easy way to populate it.

[Shaggy Hiker]

I don't think he meant to put a string in each 1d array slot and Mid$ it. A 2d array is probably layed out sequentially in memory (memory is sequential, anyways). Therefore, if you have an array with dimensions of 3 and 4, you could arrange it in a 1d array like 111122223333. To find array(x,y) you would do something like

x * <size of dimension 2> + y. This would be a one day array.

[mr_metal_hed]

Okay, I get the concept now. I decided to use a 8x3 array to store my data. The 2d array that I have discussed was just to make asking questions simpler. Since assigning 24 values in a multidimensional array isn't a major task, I will stick with what I have. If I had more values, this 1d aka fake 2d array might be useful. Also, I already have it coded... Thanks for the idea.

I guess I will mark this thread as resolved since my initial question has been answered.