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

22 votes289 views1 answer
Excel vba check if directory exists
VBA
0 vote252 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote225 views1 answer
Vba html document reference
VBA
1 vote207 views1 answer
Vbscript convert ascii code to character
VBA
0 vote229 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote211 views1 answer
Vbnet check if string is only symbols
VBA
1 vote261 views1 answer
Perform http request in vb.net
VBA
-1 vote223 views1 answer
Vba code to add new column in table
VBA
0 vote231 views1 answer
Send text to clipboard vb.net
VBA
0 vote219 views1 answer
Vba variable number of arguments
VBA