The way in which the Dictionary stores items is comparable to the Collection object. That's an advantage of a Dictionary compared to an array/matrix-variable. It's not necessary to look for an item using a loop or by applying the Excelfunction application.match. With that knowledge it's easier to compare different methods and to make a choice between them.Īn important chracteristic of a Dictionary is the use of unique keys. What a Dictionary has to offer will be discussed in detail.
This tutorial doesn't offer an exhaustive comparison of all these methods. Which one to use is dependent of your ultimate goal. With that key you can get direct access to the item (reading/writing/adapting). objectvariable 22.2.3.1 private objectvariable 22.2.3.2 public objectvariable 23 Examples 23.1 remove duplicates 23.2 Filter highest value 23.3 Filter lowest value 23.4 records autofill 23.5 worksheets integration 23.6 csv data integration 23.7 unique elementens 23.8 ActiveX controls: check polpulating 23.9 worksheeetcontrol 23.10 convert string to 2-dimensional arrayĪ Dictionary in VBA is a collectionobject: you can store all kinds of things in it: numbers, texts, dates, arrays, ranges, variables and objects.Įvery item in a Dictionary gets its own unique key. Item()= 6.2.3 =.Item() 6.2.4 objectvariable 7 Keys 7.1 string 7.2 numner 7.3 date 7.4 object 7.5 ActiveX-control 7.6 several keys 8 Unique key 9 create unique keys 10 Unique elements 11 Items 11.1 empty item 11.2 empty string 11.3 normal string 11.4 non-printable character 11.5 number 11.6 date 11.7 1-dimensional array 11.8 multi-dimensional array 11.9 object 11.10 userformcontrol 11.11 ActiveX-control 11.12 all worksheets 11.13 User Defined Type (UDT) 12 Dictionary: size 13 Search key / item 14 retrieve element 14.1 unique keys 14.2 indexnumber 14.3 indexnumber of it's key 14.4 keys: loop 14.5 Filter keys 15 key collection 15.1 store 15.2 in variable 15.3 in string 15.4 calculating with keys 15.5 Filtering keys 16 Item collection 16.1 store 16.2 in variable 16.3 in string 16.4 calculing with items 16.5 filtering items 17 Change key 18 Copy item 19 Delete item 20 Adapt item content 20.1 Replace content 20.2 Add to content 20.3 adapt / calculate 20.3.1 numbers 20.3.2 dates 20.3.3 boolean 20.4 adpt an array-item 20.4.1 1-dimensional array 20.4.2 2-dimensional array 21 Clear Dictionary 22 Early binding and late binding 22.1 Late binding 22.1.1 implicit object 22.1.2 object variable 22.2 early binding 22.2.1 implicit object 22.2.2. Item( )= 5.3 =.Item() 5.4 objectvariable 6 Add or replace 6.1 new key 6.2 existing key 6.2.1.
1 What's a Dictionary 2 The purpose of a Dictionary 3 Dictionary backgroud 4 Create a Dictionary 5 Dictionary: populating 5.1.
0 kommentar(er)
