load form into word upon opening

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

marilyn - 20 Sep 2005 19:17 GMT

I have a form that I have created in word using VBA, how do I call it up
automatically when MS Word opens? What is the code and where do I put it?

Thank you,

Reply to this Message

Anne Troy - 20 Sep 2005 19:54 GMT

Hi, Marilyn. Try this:
Sub Document_Open()
UserForm1.Show
End Sub

If it's a template, change the name to Sub Document_New()
The sub goes into ThisDocument.
************
Anne Troy
www.OfficeArticles.com

>I have a form that I have created in word using VBA, how do I call it up
> automatically when MS Word opens? What is the code and where do I put it?
>
> Thank you,

Reply to this Message

marilyn - 20 Sep 2005 20:31 GMT

Thank you Anne, It is not a template, I designed the form using VBA Forms and
called it Userform1. I am a newbie at this so please just be patient with me.
Once this has been accomplished I need to figure out out to break the form
down into two pages and then add a table. I keep telling myself one step at a
time and I will get it.

> Hi, Marilyn. Try this:
> Sub Document_Open()
[quoted text clipped - 11 lines]
> >
> > Thank you,

Reply to this Message

Anne Troy - 20 Sep 2005 22:13 GMT

Why are you using a userform in the first place? Sounds like you should be
using this:
http://www.officearticles.com/word/create_a_fill-in_form_in_microsoft_word.htm

************
Anne Troy
www.OfficeArticles.com

> Thank you Anne, It is not a template, I designed the form using VBA Forms
> and
[quoted text clipped - 21 lines]
>> >
>> > Thank you,

Reply to this Message

marilyn - 20 Sep 2005 23:36 GMT

I have been working with access and just trying to learn it on my own. This
form will work just great, Thank you! Thank you!

> Why are you using a userform in the first place? Sounds like you should be
> using this:
[quoted text clipped - 29 lines]
> >> >
> >> > Thank you,

Reply to this Message

Anne Troy - 20 Sep 2005 23:55 GMT

You're welcome! It's a lot like people who search for help on a checkbox end
up using the Control Toolbox instead of the Forms Toolbar, and it's just a
crying shame. Good luck! You'll likely be much happier with this method.
************
Anne Troy
www.OfficeArticles.com

>I have been working with access and just trying to learn it on my own. This
> form will work just great, Thank you! Thank you!
[quoted text clipped - 39 lines]
>> >> >
>> >> > Thank you,

Reply to this Message