Dim As Dictionary. Compile Error: User-defined type not defined Dim As Dictionary. Compile Error: User-defined type not defined vba vba

Dim As Dictionary. Compile Error: User-defined type not defined


Add a reference to Microsoft Scripting Runtime as @YowE3k said:

In the VBA Editor:

Tools -> References

AddRef1

Find Microsoft Scripting Runtime

Check it

Click okay

AddRef2