Can Global Classes be created in Excel

[bdbBear]

Working in WinXP/2K3.

I created a class module that I want to instantiate at Workbook_Open(). I want to be able to refer to it from any worksheet (or other class or module) until Workbook_BeforeClose().

Is this possible? I've tried the following (my class is called Message) in the Workbook but I get error messages.

Public mMsg As Message

Property Get Msg() As Message
Msg = mMsg
End Property

Property Let Msg(ByVal v As Message)
mMsg = v
End Property

The message I get is ...

Private object modules cannot be used in public object moduels as parameters or return types for public procedures, as public data members, or as fields of publis user defined types.

Thanks!

- Bruce

 

[combo]

A sample solution by Tushar Mehta:

http://support.microsoft.com/?id=555159

combo

 

[rmikesmith]

Bruce,

Your declaration, Public mMsg As Message, should be placed at the beginning of a standard code module.


Regards,
Mike