Populating a dictionary

[tiredofit]

According to this article:

http://www.snb-vba.eu/VBA_Dictionary_en.html

what is the difference between section 5.2:

With CreateObject("scripting.dictionary")
.Item("first") = "content"
End With

and section 5.4

Set dict_snb = CreateObject("scripting.dictionary")
 dict_snb.Item("first") = Date

I've written code such as:

Dim DIC As Object
    Set DIC = CreateObject("Scripting.Dictionary")


For n = 1 To TableArrayRows
    
        DIC(TableArray(n, 1)) = n
    Next n

but when I try to add named args such as:

Dim DIC As Object
    Set DIC = CreateObject("Scripting.Dictionary")


For n = 1 To TableArrayRows
    
        DIC.Item(Keys:=TableArray(n, 1)) = n
    Next n

it errors.

Can you not have named args with late binding?

Thanks

 

[RoryA]

The argument is called Key, not Keys.

 

[tiredofit]

Thanks