Class Module in Excel VBA

amkey04 · August 30th, 2004, 3:57 am

Hi,Can I call a Class Module without declaring it as Dim ABC as New XYZ? My Code looks something like this ,Function testing (i as integer,j as integer) MathOperation.sum (i,j)end functionclass module MathOperation: Function sum(x as integer, y as integer) sum = x + y end functionThanks a lot for any help in advance Amkey04

afoster · August 30th, 2004, 6:26 am

In VBA this is not possible, as the Instancing property of a Class module can only be set to either Private or PublicNotCreatable.In VB 6, you can do this by setting the Instancing property to GlobalMultiUse.

amkey04 · August 31st, 2004, 1:35 am

ah... i see now. thanks for the help afoster amkey04