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 Developersdex http://www.developersdex.com ***

On Jul 23, 1:46*pm, kalle <ka...@yahoo.com> wrote:
> 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***

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/micro...4688dd147e61f6

Best,

Matthew Herbert