Excel Circular Reference Mac And Received

Excel Circular Reference Mac And Received

I recently had a user attempt to use it on a Mac and received the following error.

Probably should copypaste some if not all of the actual code (there are 2 files, no too big) in case the link breaks so viewers can still make use of it.

Unrestricted class just to hold pairs of values together and permit Dictionary object updating.

Dictionary:.Add(Key as string, Item as variant),.CompareMode,.Count,.Exists(Key).

Public Property Let Item(Key As String, Item As Variant) dic.Item(Key) value update a scalar value for an existing key.

Public Property Set Item(Key As String, Item As Variant) Set dic.Item(Key) value update an object value for an existing key.

Public Property Get Items() As Variant for compatibility with Scripting.Dictionary.

Public Property Get KeyValuePair(Index As Long) As Variant returns KeyValuePair object.

Private Sub AssignVariable(variable As Variant, value As Variant).

NB VBA Collection object index is 1-based, scripting.dictionary items array is 0-based.

Scripting.Dictionary has no index number; you can index the 0-based variant array of Items returned.

Efficient iteration is For Each varPair in thisdic.KeyValuePairs.

Another difference I introduce is that in a scripting.dictionary, the doc says.

Kudos to you for both posting the solution and for pulling out the actual code.

So I had to create a class module and to copy and paste the contents of Dictionary.cls manually in that module while removing meta info from Dictionary.cls such as VERSION 1.0 CLASS, BEGIN, END, Attribute.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel vba macos dictionary or ask your own question.

Excel For Mac Circular Reference