User Form, Stay/w Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

boborta@hotmail.com - 20 Mar 2007 23:21 GMT

I am not new to VBA, but I am to user forms in Word.

I have created a user form that populates form fields in a document
based on the value selected in a drop down. Everything works good.
It appears that the form and code are part of normal.dot, rather than
the document. I need to provide user's copies of the document w/the
form & code and do not want to copy my normal.dot to their PC's. How
do I make the form/code p/o the document? Any help with would be
appreciated.

Bob

Reply to this Message

Jean-Guy Marcil - 20 Mar 2007 23:47 GMT

boborta@hotmail.com was telling us:
boborta@hotmail.com nous racontait que :

> I am not new to VBA, but I am to user forms in Word.
>
[quoted text clipped - 7 lines]
>
> Bob

Do you want to distribute a *.doc or a *.dot?

Use the VBA editor to drag and drop the userform and standard modules from
your Normal.dot to your target (In the Project pane).

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Reply to this Message

boborta@hotmail.com - 21 Mar 2007 02:13 GMT

I want to distribute a *.doc. I wondered about dragging the user form/
code, but did not try it.

Thanks for the reply.
Bob

> Do you want to distribute a *.doc or a *.dot?
>
[quoted text clipped - 8 lines]
> jmarcilREM...@CAPSsympatico.caTHISTOO
> Word MVP site:http://www.word.mvps.org

Reply to this Message