Python dictionary in VBA

Quote:

---

Originally Posted by p45cal

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"
Attachment 30676

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

Attachment 30677

or:
change the lines:

Code:

---

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

---

to:

Code:

---

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

---

and change the line:

Code:

---

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

---

to:

Code:

---

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

---

Quote:

---

Originally Posted by p45cal

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

Yep, i was missing that!:yes
Attachment 30677

or:
change the lines:

Code:

---

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

---

to:

Code:

---

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

---

and change the line:

Code:

---

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

---

to:

Code:

---

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

---

---

Quote:

---

Originally Posted by p45cal

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 :

Code:

---

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

---

Attachment 30677

or:
change the lines:

Code:

---

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

---

to:

Code:

---

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

---

and change the line:

Code:

---

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

---

to:

Code:

---

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

---

---

Quote:

---

Originally Posted by Einsener37

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.