Relate a Number with an ARRAY
 

I would like to have some kind of relationship established between numbers
and Arrays. For example, if I call number 1234, I want it to return an
ArrayA(1 to 10) . Library Variables won't work because I can't have Arrays
stored in the Items slot. What can I do?

Relate a Number with an ARRAY
 

I would like to have some kind of relationship established between numbers
and Arrays. For example, if I call number 1234, I want it to return an
ArrayA(1 to 10) . Library Variables won't work because I can't have Arrays
stored in the Items slot. What can I do?

Can you explain what you want to do in more detail? ArrayA(1 to 10) is
something you would find in a Dim or ReDim statement, so I am not completely
sure what you are after.

Rick

Relate a Number with an ARRAY
 

OK heres an example:

I have Basket # 1908765
In Basket # 1908765, there are 10 items.

I store the 10 items in an array.
I want it so that when the Basket # 1908765 is called, the array is returned.

Hope that clears it up abit.




"Rick Rothstein (MVP - VB)" wrote:

I would like to have some kind of relationship established between numbers
and Arrays. For example, if I call number 1234, I want it to return an
ArrayA(1 to 10) . Library Variables won't work because I can't have Arrays
stored in the Items slot. What can I do?

Can you explain what you want to do in more detail? ArrayA(1 to 10) is
something you would find in a Dim or ReDim statement, so I am not completely
sure what you are after.

Rick

Relate a Number with an ARRAY
 

You can use a collection something like this...

Sub Test()
Dim aryA(1 To 2) As Integer
Dim ary() As Integer
Dim col As Collection

Set col = New Collection

aryA(1) = 123
aryA(2) = 234

col.Add aryA, "12345"

aryA(1) = 987
aryA(2) = 654

col.Add aryA, "98765"

ary = col.Item("12345")
MsgBox ary(1)
ary = col.Item("98765")
MsgBox ary(1)
End Sub
--
HTH...

Jim Thomlinson


"J@Y" wrote:

OK heres an example:

I have Basket # 1908765
In Basket # 1908765, there are 10 items.

I store the 10 items in an array.
I want it so that when the Basket # 1908765 is called, the array is returned.

Hope that clears it up abit.




"Rick Rothstein (MVP - VB)" wrote:

I would like to have some kind of relationship established between numbers
and Arrays. For example, if I call number 1234, I want it to return an
ArrayA(1 to 10) . Library Variables won't work because I can't have Arrays
stored in the Items slot. What can I do?

Can you explain what you want to do in more detail? ArrayA(1 to 10) is
something you would find in a Dim or ReDim statement, so I am not completely
sure what you are after.

Rick

Relate a Number with an ARRAY
 

So I assume Collection allows arrays to be stored in the "items" whereas
Dictionary doesnt?

"Jim Thomlinson" wrote:

You can use a collection something like this...

Sub Test()
Dim aryA(1 To 2) As Integer
Dim ary() As Integer
Dim col As Collection

Set col = New Collection

aryA(1) = 123
aryA(2) = 234

col.Add aryA, "12345"

aryA(1) = 987
aryA(2) = 654

col.Add aryA, "98765"

ary = col.Item("12345")
MsgBox ary(1)
ary = col.Item("98765")
MsgBox ary(1)
End Sub
--
HTH...

Jim Thomlinson


"J@Y" wrote:

OK heres an example:

I have Basket # 1908765
In Basket # 1908765, there are 10 items.

I store the 10 items in an array.
I want it so that when the Basket # 1908765 is called, the array is returned.

Hope that clears it up abit.




"Rick Rothstein (MVP - VB)" wrote:

I would like to have some kind of relationship established between numbers
and Arrays. For example, if I call number 1234, I want it to return an
ArrayA(1 to 10) . Library Variables won't work because I can't have Arrays
stored in the Items slot. What can I do?

Can you explain what you want to do in more detail? ArrayA(1 to 10) is
something you would find in a Dim or ReDim statement, so I am not completely
sure what you are after.

Rick

Relate a Number with an ARRAY
 

Why not try both and check? If nothing else you'll learn some more
about each of the data structures.

In article ,
says...
So I assume Collection allows arrays to be stored in the "items" whereas
Dictionary doesnt?

{snip}

Relate a Number with an ARRAY
 

Yup... That's pretty much it.
--
HTH...

Jim Thomlinson


"J@Y" wrote:

So I assume Collection allows arrays to be stored in the "items" whereas
Dictionary doesnt?

"Jim Thomlinson" wrote:

You can use a collection something like this...

Sub Test()
Dim aryA(1 To 2) As Integer
Dim ary() As Integer
Dim col As Collection

Set col = New Collection

aryA(1) = 123
aryA(2) = 234

col.Add aryA, "12345"

aryA(1) = 987
aryA(2) = 654

col.Add aryA, "98765"

ary = col.Item("12345")
MsgBox ary(1)
ary = col.Item("98765")
MsgBox ary(1)
End Sub
--
HTH...

Jim Thomlinson


"J@Y" wrote:

OK heres an example:

I have Basket # 1908765
In Basket # 1908765, there are 10 items.

I store the 10 items in an array.
I want it so that when the Basket # 1908765 is called, the array is returned.

Hope that clears it up abit.




"Rick Rothstein (MVP - VB)" wrote:

I would like to have some kind of relationship established between numbers
and Arrays. For example, if I call number 1234, I want it to return an
ArrayA(1 to 10) . Library Variables won't work because I can't have Arrays
stored in the Items slot. What can I do?

Can you explain what you want to do in more detail? ArrayA(1 to 10) is
something you would find in a Dim or ReDim statement, so I am not completely
sure what you are after.

Rick

Relate a Number with an ARRAY
 

Great, Thanks for the clarification.

"Jim Thomlinson" wrote:

Yup... That's pretty much it.
--
HTH...

Jim Thomlinson


"J@Y" wrote:

So I assume Collection allows arrays to be stored in the "items" whereas
Dictionary doesnt?

"Jim Thomlinson" wrote:

You can use a collection something like this...

Sub Test()
Dim aryA(1 To 2) As Integer
Dim ary() As Integer
Dim col As Collection

Set col = New Collection

aryA(1) = 123
aryA(2) = 234

col.Add aryA, "12345"

aryA(1) = 987
aryA(2) = 654

col.Add aryA, "98765"

ary = col.Item("12345")
MsgBox ary(1)
ary = col.Item("98765")
MsgBox ary(1)
End Sub
--
HTH...

Jim Thomlinson


"J@Y" wrote:

OK heres an example:

I have Basket # 1908765
In Basket # 1908765, there are 10 items.

I store the 10 items in an array.
I want it so that when the Basket # 1908765 is called, the array is returned.

Hope that clears it up abit.




"Rick Rothstein (MVP - VB)" wrote:

I would like to have some kind of relationship established between numbers
and Arrays. For example, if I call number 1234, I want it to return an
ArrayA(1 to 10) . Library Variables won't work because I can't have Arrays
stored in the Items slot. What can I do?

Can you explain what you want to do in more detail? ArrayA(1 to 10) is
something you would find in a Dim or ReDim statement, so I am not completely
sure what you are after.

Rick