ArrayList or equiv in VBA?

[survivalist]

Hi,

I'm looking for something like ArrayList in VBA. I can't seem to find
anything...or is there a way to use the standard VB collections?

Thanks!

 

[Michael Bauer]

Am 24 Jul 2006 18:11:42 -0700 schrieb (e-mail address removed):

You can use collections:

Dim col as VBA.Collection
Set col=New VBA.Collection

or an array, e.g. for 10 items (0 to 9):

Dim ar(9) As Variant ' or As String etc.

or an expandable array:

ReDim ar(9) as Variant
...
ReDim ar(19)

If you need a chained list you´d have to build that yourself.