Hi,

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
Max

I variable at module level is valid until the class goes out of scope. For example, the variable

private m_localVariable as Long

is recognized in all the methods of the same class, but it is lost when the class is destroyed.
Can you publish your code? Maybe there is something else going on
Marco

Hi marco,

I just found out how it works, exactly how you said it would work. I have put the variables in cells, so the problem is solved.

Thanks for the help anyway.

Max