Vba createobject system collections arraylist
vba system.collections.arraylist 2d code exampleExample: excel vba arraylist'VBA does not include a native ArrayList memory structure. 'However, VBA can create and use a .NET ArrayList: Set ArrayList = CreateObject("System.Collections.ArrayList") ArrayList.Add "World" ArrayList.Add "Hello " ArrayList.Sort MsgBox ArrayList(0) & ArrayList(1) '<--displays: Hello World 'Notes: Since this calls .NET, an ArrayList is slower than a VBA array. ' The most compelling reason to use an ArrayList is the built-in ' Sort method. VBA arrays do not have a built-in sort capability. ' Neither do collections or dictionaries. But, the .NET ArrayList ' does. ' ' The .NET ArrayList also includes a 'ToArray' method: vArr = ArrayList.ToArray ' This will create a normal 1D VBA array with a lowerbound of zero ' where the elements coincide with the items in the ArrayList. ' The .NET ArrayList has many properties and methods: ' https://docs.microsoft.com/en-us/dotnet/api/system.collections.arraylist ' ' ' |
