ArrayList or equiv in VBA?
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! |
ArrayList or equiv in VBA?
Am 24 Jul 2006 18:11:42 -0700 schrieb :
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! |
All times are GMT +1. The time now is 08:26 PM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com