Reference class instantiated in ThisWorkbook module

[tinkythomas]

Hi,
I have a class that I instantiate in the Workbook_Open event in the ThisWorkbook module. How do I properly reference it outside the module? I have tried MyClass.Property syntax but intellisense doesn't pop up with the property name after I type the period like it should do. This leads me to believe that I'm not referencing properly?

Any help would be appreciated.

Regards,

 

[shg]

The class variable should be declared as Public in a standard code module.

 

[tinkythomas]

The class variable should be declared as Public in a standard code module.

Sorry, I don't follow? Your saying I need to declare the class twice, even though it's been instantiated in the ThisWorkbook module?

Thanks for the reply.

 

[shg]

An instance of a class is assigned to an object variable. If that variable is to be accessed outside the module where the instance is created, then the class variable must be Public, which means it has to be declared in a standard code module.

If that's not clear, then post your code.

 

[tinkythomas]

Thank you very much, sorry for the misunderstanding! I was declaring the class variable inside the Workbook_Open sub instead of the declarations section of a standard module.

All is working as expected now!

Thanks again,

 

[shg]

All is working as expected now!

Good job, you're welcome.