I use the = new syntax when I display a userform. e.g.
I have built a form called Frm_Status
In my stanndard code :
Dim F_Status as Frm_Status
set F_Status = new Frm_Status
So I am creating a new object called F_Status that is a copy of Frm_Status.
When I am in the Sub that "set" the userform, I can update F_Status and adjust it by addressing it as F_Status.controlname . However, in a different called Sub, I can't address the active F_Status form that is displayed.
I can find it by:
For Each oForm in Userforms()
but is there another way?
Hope this is clear ...