Quick question about arrays

[Graff]

How do you make 2 dimsional arrays
for example I'm making a mock store for my systems class and I want products to be under catagories so I have like a coleman 2-person tent under the catagory of Tents. I was trying to use something like

Public Products(39,39) as string (I know hard code is bad but this program doesn't need to be scaleable)

then
Products(0) = "Tents"
Products(0,0) = "Coleman 2-person tent"

I get a compile error on the first

Any help would be appriciated.

[Graff]

hhmm maybe it would be better if I used a collection

[MartinLiss]

Products(0, 0) = "Tents"
Products(0, 1) = "Coleman 2-person tent"

You can also create a User Defined Type

Option Explicit
Private Type StockType
    strCategory As String
    strItem As String
End Type

Private Sub Form_Load()

    Dim Products(39) As StockType
    
    Products(0).strCategory = "Tents"
    Products(0).strItem = "Coleman 2-person tent"
    
    Products(1).strCategory = "Tents"
    Products(1).strItem = "Coleman 8-person tent"
    
    Products(1).strCategory = "Coolers"
    Products(1).strItem = "Mini"
    
End Sub

[Graff]

Are you talking to me or martin, jason?

That type idea is good thanks... whoever wrote it.