Using Class Modules in Userforms

[svjack9]

This is a general question regarding when a class has to be instantiated in Excel VBA. If I create a class object (let's call it oSession) in Userform_Initialize() can I use that instance of the class in other form procedures?
For example:
UserForm_initialize()
Dim oSession as New Session
with oSession
.Property1=Data1
.Property2=Data2
End with
End Sub

Does oSession go out of scope at "End Sub" or can I pass oSession to other procedures used by the form? My guess is that it goes out of scope, but I'm hoping there is a way to do it.

Hope I've used the right terminology, but, if not, I'm open to learning!

Svjack9

 

[Jaafar Tribak]

Yes. oSession will go out of scope at "End Sub"

In order to preserve the class instance,you can pass it as an argument to other procedures used by the form but within the initialize event sub. (ie: before reaching "End Sub")

You can aslo add it to a collection but the collection must be declared at the top of the userform module.

Why don't you simply declare oSession at the top of the userform module ?

 

[svjack9]

That will solve multiple issues! Thanks for your reply.