Re: ArrayList or equiv in VBA?



Am 24 Jul 2006 18:11:42 -0700 schrieb survivalist@xxxxxxxxx:

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.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


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