Combat Womble
New Member
- Joined
- Nov 18, 2015
- Messages
- 30
Hello everyone,
I have a class module in my personal work book. I am trying to instansitate this object from a module in a seperate workbook and I keep getting a User-defined type not defined error.
I have:
set the class to private and publicnotcreatable settings.
added Microsoft Scripting Runtime library
used the following syntax (NameMap is the name of the class)
If I copy the class code into the worksheet (not personal workbook) it will run.
The reason I want this to be in my personal workbook is that the dictionary it holds is long and requires updating every so often. One place one update.
I am sure I am doing something simple wrong.
Please advise me
Combat Womble
I have a class module in my personal work book. I am trying to instansitate this object from a module in a seperate workbook and I keep getting a User-defined type not defined error.
I have:
set the class to private and publicnotcreatable settings.
added Microsoft Scripting Runtime library
used the following syntax (NameMap is the name of the class)
VBA Code:
Dim nameChecker As NameMap
Dim nameChecker As Object
Dim nameChecker As Varient
Set nameChecker = New NameMap
Dim nameChecker As New NameMap
The reason I want this to be in my personal workbook is that the dictionary it holds is long and requires updating every so often. One place one update.
I am sure I am doing something simple wrong.
Please advise me
Combat Womble