Class module variables in VB6
I have made an ActiveX DLL with a few class modules in it. In each class module, a few subroutines exist.
I have one class module, where it is important to remember a specific variable set in a subroutine. I made this variable public using the "public" statement. These subroutines are called from Excel.
However, when I print this variable out in another subroutine (i.e. msgbox (variable) ) , it says the variable isnt set (msgbox nothing)
There is a way to store these variables in the memory. But how? Does the DLL not remember the variables because it is called from Excel?
Help will be appreciated