You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, thanks for making this dictionary replacement for VBA. I'm having trouble getting it to work though. Currently I'm getting a syntax error when I try to define a dictionary. No error codes with the syntax error, but it points me to the following lines with the second line (Attribute Count.VB... ) highlighted:
Public Property Get Count() As Long
Attribute Count.VB_Description = "Get the number of items in the dictionary.\n"
#If Mac Or Not UseScriptingDictionaryIfAvailable Then
Count = dict_pKeyValues.Count
#Else
Count = dict_pDictionary.Count
#End If
End Property
Is this a known issue or do you have any suggestions on tracing back the issue?
I'm using Excel 2016 for mac, OSX 10.15.7
Thanks!
Edit: code block formatting
The text was updated successfully, but these errors were encountered:
Hi, that seems to be an artefact from (mis-)importing the module. When importing, the Attribute (propertyname).VB_Description directive is used to assign a description to the count property, which then could be viewed in the object browser in the VBA IDE.
Simply delete it or comment it to debug.
Hi, thanks for making this dictionary replacement for VBA. I'm having trouble getting it to work though. Currently I'm getting a syntax error when I try to define a dictionary. No error codes with the syntax error, but it points me to the following lines with the second line (Attribute Count.VB... ) highlighted:
Is this a known issue or do you have any suggestions on tracing back the issue?
I'm using Excel 2016 for mac, OSX 10.15.7
Thanks!
Edit: code block formatting
The text was updated successfully, but these errors were encountered: