-
Notifications
You must be signed in to change notification settings - Fork 89
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Not working for Excel 2021 #38
Comments
In your first method, how did you download the code? If you downloaded it using the .zip download option and you unzip it, it should work: https://github.com/VBA-tools/VBA-Dictionary/releases There is a problem with the download raw file option because it will not convert Unix-style line-endings (LF) to Windows-style line endings (CRLF) and the VBE expects files to use CRLF. |
Thank you! I had this same issue when using the download raw file option. The .zip download option worked! |
This repository does not seem to be maintained. Alternatively use VBA-FastDictionary which is well tested and faster |
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 statement
atVERSION 1.0 CLASS
removing that results in:
Compile error: Invalid outside procedure
atBEGIN
removing that block results in:
Compile error: A module is not a valid type
at my codeDim dict As New Dictionary
Create a new
class module
by right click the project (root), thenInsert -> Class Module
, copy the code ofDictionary.cls
in there, rename the class module to Dictionaryresults in:
Compile error: Expected: end of statement
atVERSION 1.0 CLASS
removing that results in:
Compile error: Invalid outside procedure
atBEGIN
removing that block results in:
Compile error: Syntax error
atAttribute VB_Name = "Dictionary"
removing that block results in
Run-time error 438: Object doesn't support this property or method
at my codedict("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.
The text was updated successfully, but these errors were encountered: