I've tried several things, and I get various error messages.
-
Import the cls file
results in: It's imported under modules. Using it gives Compile error: Expected: end of statement at VERSION 1.0 CLASS
removing that results in: Compile error: Invalid outside procedure at BEGIN
removing that block results in: Compile error: A module is not a valid type at my code Dim dict As New Dictionary
-
Create a new class module by right click the project (root), then Insert -> Class Module, copy the code of Dictionary.cls in there, rename the class module to Dictionary
results in: Compile error: Expected: end of statement at VERSION 1.0 CLASS
removing that results in: Compile error: Invalid outside procedure at BEGIN
removing that block results in: Compile error: Syntax error at Attribute VB_Name = "Dictionary"
removing that block results in Run-time error 438: Object doesn't support this property or method at my code dict("a") = "b"
-
Run VBA-Dictionary - Specs.xlsm
results in: Compile error: The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute.
I've tried several things, and I get various error messages.
Import the cls file
results in: It's imported under
modules. Using it givesCompile error: Expected: end of statementatVERSION 1.0 CLASSremoving that results in:
Compile error: Invalid outside procedureatBEGINremoving that block results in:
Compile error: A module is not a valid typeat my codeDim dict As New DictionaryCreate a new
class moduleby right click the project (root), thenInsert -> Class Module, copy the code ofDictionary.clsin there, rename the class module to Dictionaryresults in:
Compile error: Expected: end of statementatVERSION 1.0 CLASSremoving that results in:
Compile error: Invalid outside procedureatBEGINremoving that block results in:
Compile error: Syntax erroratAttribute VB_Name = "Dictionary"removing that block results in
Run-time error 438: Object doesn't support this property or methodat my codedict("a") = "b"Run
VBA-Dictionary - Specs.xlsmresults in:
Compile error: The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute.