Default item function not working

VBA-tools / VBA-Dictionary

Drop-in replacement for Scripting.Dictionary on Mac

MIT License

348 stars 89 forks source link

Default item function not working #22

Closed abeyer99 closed 5 years ago

abeyer99 commented 5 years ago

Hi, the default functionality for Scripting.Dictionary is the item function. But your dictionary does not do this for me. My key is a string and my item is a custom object. I am testing your dictionary on my Windows 10 machine. Excel 2016 version 1906. When I do dict.item(key), it works, though.

timhall commented 5 years ago

There is an attribute set for Item that should do this (Attribute Item.VB_UserMemId = 0), but attributes are only retained if you import Dictionary.cls into your project (i.e. copy-pasting code from Dictionary won't set the attribute). Try the following Installation Instructions:

Download the latest release, unzip, and import Dictionary.cls into your VBA project.

If it's still not working after importing, please re-open this issue and let me know