Global variables in Excel VBA

Hi,

I am trying to create an instance of a user defined class within a worksheet (Excel VBA) such that I can use the class variables as a cache for a large amout of data.

I have tried:

Public myClass as CMyClass
--------------------------
Public Sub load()

Set myClass = new CMyClass

End sub

public sub load()

myClass.callLoaderFunction()

end sub

But i get a "type mismatch - error 13" when I try and call the load() function.

Any ideas?

http://www.vbforums.com/attachment.p...id=47243&stc=1

I moved your thread to here which is the place for questions concerning VBA.

Where is "callLoaderFunction"? What is its return type? You could create public properties in the class.