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 !
- 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.
- 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.
- 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 !