any recommendation for best tutorial to learn scripting dictionary in VBA?

**flora** · 11-24-2017, 08:26 PM

I am very much interested to learn use of scripting dictionary in VBA and use of Arrays in VBA for Excel.

do you have any recommendation where should i start? blog, book, video tutorial.

thanks.

**Kenneth Hobson** · 11-24-2017, 10:21 PM

Seems like you have asked this in other forums.

First, get the help file script56.chm. It will show properties and methods and examples. Get it in the 3rd link in Reference section. http://www.robvanderwoude.com/wshlinks.php

Here is how I used it.

Code:

'Early Binding method requires Reference: MicroSoft Scripting Runtime, scrrun.dll
Function UniqueArrayByDict(Array1d As Variant, Optional compareMethod As Integer = 0) As Variant
  Dim dic As Object 'Late Binding method - Requires no Reference
  Set dic = CreateObject("Scripting.Dictionary")  'Late or Early Binding method
  'Dim dic As Dictionary     'Early Binding method
  'Set dic = New Dictionary  'Early Binding Method
  Dim e As Variant
  dic.CompareMode = compareMethod
  'BinaryCompare=0
  'TextCompare=1
  'DatabaseCompare=2
  For Each e In Array1d
    If Not dic.Exists(e) Then dic.Add e, Nothing
  Next e
  UniqueArrayByDict = dic.Keys
End Function