associative arrays

  • Thread starter Thread starter kalle
  • Start date Start date
K

kalle

Hi

Is it possible to use Associative arrays in vba?

If possible, I would be glad if someone could show me how.

Thanks in advance
 
Hi

Is it possible to use Associative arrays in vba?

If possible, I would be glad if someone could show me how.

Thanks in advance

*** Sent via Developersdexhttp://www.developersdex.com***
Click to expand...

Kalle,

I can't say that I'm familiar with "associative arrays" (but this may
simply be a diction issue); however, a quick Internet scan leads me to
beleive that each element has a value and a key. If this is the case,
then look into using a Collection or Dictionary object. (For a
collection, this is assuming that you will know what the key is
though. Also, a Collection won't let you add a duplicate key).

There are some good discussion points in the following thread:
http://groups.google.com/group/micr...1f6?lnk=gst&q=collection+key#2a4688dd147e61f6

Best,

Matthew Herbert
 
Back
Top