I have created ClassLibrary1 DLL successfully using VSStudio2019. Also, added the .tlb as reference withing VBA.
But when I set the object, I get "ActiveX cant create object". My DLL namespace is ClassLibrary1 and the class within the namespace is Class1 and function within is TestFunction().
Dim obj as Object
Set obj = New Class1
Debug.Print obj.TestFunction("sometext")
When I type obj, the intellisense does display all the functions within the Class1.
Please help.
But when I set the object, I get "ActiveX cant create object". My DLL namespace is ClassLibrary1 and the class within the namespace is Class1 and function within is TestFunction().
Dim obj as Object
Set obj = New Class1
Debug.Print obj.TestFunction("sometext")
When I type obj, the intellisense does display all the functions within the Class1.
Please help.