Discussion:
Accessing userform in doc from addin
(too old to reply)
zSplash
2006-11-07 20:19:34 UTC
Permalink
I have an addin used with many forms. I have a userform in one of the forms
that I want to access from the addin, while working the form. I do not want
to include the userform in the addin, for size reasons. How do I reference
a userform in a doc from an addin?

Unsuccessfully tried, from myAddin, accessing ufm1 in form1 by:
ufm1.show
form1.ufm1.show
form1!ufm1.show

TIA!
Astrid
2006-11-20 11:06:01 UTC
Permalink
Hi zSplash,

If you want to use a form from within one template and use it in another,
you'll need a reference between the two templates (Tools - References in the
VBE)
Then write a procedure that shows the userform in the template where the
form 'lives' and call that procedure from within the other template.

Kind regards,
Astrid
Post by zSplash
I have an addin used with many forms. I have a userform in one of the
forms that I want to access from the addin, while working the form. I do
not want to include the userform in the addin, for size reasons. How do I
reference a userform in a doc from an addin?
ufm1.show
form1.ufm1.show
form1!ufm1.show
TIA!
Loading...