Vba collection key list

' Use a Dictionary instead of a Collection
Dim dict As Dictionary
Set dict = New Dictionary

dict.Add "key1", "value1"
dict.Add "key2", "value2"

Dim key As Variant
For Each key In dict.Keys
    Debug.Print "Key: " & key, "Value: " & dict.Item(key)
Next

Source: stackoverflow.com

Similar codes

0 vote226 views1 answer
Excel text to columns line break
VBA
0 vote186 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote216 views1 answer
Excel VBA web scraping
VBA
0 vote223 views1 answer
How to use if condition in time vba
VBA
0 vote246 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote202 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote215 views1 answer
Vba copy paste value only
VBA
0 vote256 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote217 views1 answer
Vba text to general
VBA
11 votes506 views1 answer
Excel vba How to URL encode a string
VBA