Multiple UserForm instances

[agibsonsw]

In VBA (Word for my current example) we can create more than one instance of the same form:

Code: Select all

Private frmNewInstance As Object

Private Sub CommandButton1_Click()
    Set frmNewInstance = UserForms.Add(Me.Name)
    frmNewInstance.Tag = "OtherOne"
    frmNewInstance.Show
    
End Sub

Private Sub UserForm_Terminate()
    Set frmNewInstance = Nothing
End Sub

I am anticipating that it will be tricky to distinguish between the different instances, which is why I'm considering using the Tag property.

Are there other pitfalls I should be aware of?

[HansV]

Do you have a specific reason for wanting to create multiple instances of a userform, or is it just curiosity?

[agibsonsw]

Curiosity

[HansV]

I wouldn't worry too much then...

But seriously, a userform is / acts as a class. So just handle it the way you would handle a class.

[agibsonsw]

Ta @Hans. Yeah, I won't worry