ArrayList or equiv in VBA?

S

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!
 
M

Michael Bauer

Am 24 Jul 2006 18:11:42 -0700 schrieb [email protected]:

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.
 
Top