Description
I'm having a little trouble installing this in a fresh document. Here's what I tried:
(1) In Excel 2011 for Mac, if I right-click on "Class Modules", choose "Import File ...", and select Dictionary.cls, I get this error:
"The form class contained in '[my path]:Dictionary.cls' is not supported in VBA. The file can't be loaded."
(2) If I create a new Class Module, name it Dictionary, and paste the contents of Dictionary.cls in, then the class sort of works, but assignment is broken:
Dim test As New Dictionary
' this works:
test.Add "Bar", "Baz"
' this doesn't work:
test("Key") = "Foo"
'=> Run-time error '438': Object doesn't support this property or method
(3) If I open an existing project that already has this installed (like VBA-Web - blank.xslm), the code above does work. So I know that Excel 2011 is compatible -- I must just be doing something wrong during the install.
Many thanks -- VBA-tools looks like some great work, and super helpful if I can just get it working. :)
Thanks,
Jack