![]() ![]() ![]() The Collection is in the RAM memory and can therefore be approached very fast. You can approach and manipulate elements in a Collection separately: read, write, calculate, change, replace, save, etc. You can store all kinds of elements in a Collection, comparable to an Array or a Dictionary.Įlements in a Collection can be strings, numbers, dates, VBA-objects, arrays, instances of Classes, etc. End With 2.4 Naming convention 3 Elements in the Collection 3.1 Add elements 3.2 Add using keys 3.3 Order of elements 3.3.1 Order by Index 3.3.2 Order by Key 3.3.3 Order by Content 4 Collection size 5 Retrieve an Element 5.1 By indexnumber 5.2 By Key 5.3 By Content 6 Element's availablity 6.1 By Key 6.2 By Content 7 Filtering Elements 7.1 By Indexnumbers 7.2 By Keys 7.3 By Content 8 Delete Elements 8.1 By Indexnumber 8.2 By Key 8.3 By Content 8.4 Delete all Elements 9 Sorting a Collection 10 ExampleĬollection is part of the standard VBA-library.Ī Collection is a set of several elements. 1 What is a Collection 2 Create a Collection 2.1 Method Dim 2.2 Method Set 2.3 Method With.
0 Comments
Leave a Reply. |