Python dictionary in VBA

[Einsener37]

Make it easy for us to help you, supply a workbook with where you've got to so far.

Over here you have to change it to "Sheet1"
Capture3.jpg

[p45cal]

Either:
In the VBE, go to Tools|References… and tick Microsoft Scripting Runtime

2023-03-27_142848.jpg

or:
change the lines:

Dim rebars2  As Scripting.Dictionary
Set rebars2 = New Scripting.Dictionary

to:

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

and change the line:

        lb.AddItem rebars2.Items(i) & " - " & rebars2.Keys(i)

to:

        lb.AddItem rebars2.Items()(i) & " - " & rebars2.Keys()(i)

[Einsener37]

Either:
In the VBE, go to Tools|References… and tick Microsoft Scripting Runtime

Yep, i was missing that!
2023-03-27_142848.jpg

or:
change the lines:

Dim rebars2  As Scripting.Dictionary
Set rebars2 = New Scripting.Dictionary

to:

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

and change the line:

        lb.AddItem rebars2.Items(i) & " - " & rebars2.Keys(i)

to:

        lb.AddItem rebars2.Items()(i) & " - " & rebars2.Keys()(i)

[Einsener37]

Either:
In the VBE, go to Tools|References… and tick Microsoft Scripting Runtime
Yeah, i was missing that
Could you explain, why do you need extra parentheses to line :

lb.AddItem rebars2.Items()(i) & " - " & rebars2.Keys()(i)

2023-03-27_142848.jpg

or:
change the lines:

Dim rebars2  As Scripting.Dictionary
Set rebars2 = New Scripting.Dictionary

to:

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

and change the line:

        lb.AddItem rebars2.Items(i) & " - " & rebars2.Keys(i)

to:

        lb.AddItem rebars2.Items()(i) & " - " & rebars2.Keys()(i)

[p45cal]

Could you explain, why do you need extra parentheses to line :

I don't know, I just did a bit of research and that's what's needed if you use late binding (that is, if you're not using the Microsoft Scripting Runtime reference)

ps, don't quote the whole post, I didn't notice at first that you'd added a question in among the quote.