L
Lieven Mettepenningen
Hello,
I'm having the following problem. I've defined a class module in an add-in,
and I want to use this class module in a workbook that uses this add-in. The
name of the class is 'DictionaryClass'. But when I enter the following line
in my workbook: 'public dict as DictionaryClass', I get a runtime-error,
because Excel complains that it doesn't know the user-defined type. Is there
a special syntax for such a use? I already managed to do this for the
initialization of the object. I first entered: 'Set dict = new
DictionaryClass', but this also gave a runtime-error. I then made a public
function in one of my code modules in the add-in that creates a
DictionaryClass-object, and returns it to the workbook, and I called this
public function from my workbook with the notation 'Application.Run.....'.
Does anyone know if I can do a similar thing for the declaration of the
object.
The important thing is that I use the add-in, but I DON'T want to use a
reference to the add-in. That's also the reason why a have to use the
"Application.Run"-syntax. Can anyone help me with this problem?
Thx,
Lieven
I'm having the following problem. I've defined a class module in an add-in,
and I want to use this class module in a workbook that uses this add-in. The
name of the class is 'DictionaryClass'. But when I enter the following line
in my workbook: 'public dict as DictionaryClass', I get a runtime-error,
because Excel complains that it doesn't know the user-defined type. Is there
a special syntax for such a use? I already managed to do this for the
initialization of the object. I first entered: 'Set dict = new
DictionaryClass', but this also gave a runtime-error. I then made a public
function in one of my code modules in the add-in that creates a
DictionaryClass-object, and returns it to the workbook, and I called this
public function from my workbook with the notation 'Application.Run.....'.
Does anyone know if I can do a similar thing for the declaration of the
object.
The important thing is that I use the add-in, but I DON'T want to use a
reference to the add-in. That's also the reason why a have to use the
"Application.Run"-syntax. Can anyone help me with this problem?
Thx,
Lieven