• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

A Dictionary for Mac & Windows …

Status
Not open for further replies.

Marc L

Excel Ninja
Hello,​
this is a dictionary like the Windows ActiveX Scripting.Dictionary​
working whatever on Mac or under Windows with more features just with VBA basics !​
  1. First download the below text file attachment.
    Once on your local hard drive, rename it just removing the .txt extension in order it's only a .cls file type.

  2. On VBE side right click on your VBA project and choose the option to import a file then select the dictionary .cls file type
    so once done you must see a new class module called MDictionary.

  3. In your VBA procedure start to declare an object variable like Dim oDic As New MDictionary
    then the use it's pretty likely the classic Windows Dictionary …
For more help according to this forum rules (in particular How to get the Best Results)
the better is to create your own thread in the appropriate VBA Macros section​
with your best accurate elaboration and a workbook attachment well reflecting your need.​
Do you like it ? So thanks to click on bottom right Like !​
 

Attachments

  • Dictionary Collection class .cls.txt
    3.9 KB · Views: 21
Status
Not open for further replies.
Back
Top