Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2007

Tip: Looking for answers? Try searching our database.

Conditional Macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RPMitchal - 15 Oct 2007 18:36 GMT
Word 2003

I have a form document that is comprised of a series of six questions.  Each
question is followed by a Check Box;

The CheckBox Bookmarks are named:  Schedule1A, Schedule2A, etc. ending with
Schedule6A

I would like to set up a macro that begins with a *Submission Button* which
would appear at the end of the form, analyze the condition of the preceding
CheckBoxes and *fire* the remainder of the macro, which would be…

If the Check Box for Schedule1A is checked, insert Document No. XYZ at the
end of the current document, followed by a Section Break

If the Check Box for Schedule2A is checked, insert Document No. ABC at the
end of the current document, followed by a Section Break

So forth and so on, up to and including Schedule6A

The reason for wanting the Section Breaks between the inserted documents is
to facilitate the reordering of the subsequent compiled document if needed.  

If any one of you has a suggestion as to how to go about the above, I would
be most appreciative.  This is my first undertaking of anything beyond simple
recorded macros – so please be gentle!  

Hopefully, I’ve written out this macro scenario in a manner that is capable
of being understood.  

Thanking you in advance, I remain…

Very truly yours – Rod
Jean-Guy Marcil - 17 Oct 2007 21:36 GMT
RPMitchal was telling us:
RPMitchal nous racontait que :

> Word 2003
>
[quoted text clipped - 31 lines]
>
> Very truly yours - Rod

You can start with this:
   http://word.mvps.org/faqs/Userforms/index.htm
use the first link "How to create a Userform".

Post back in a new thread with more specific questions.

Signature

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

RPMitchal - 26 Oct 2007 15:32 GMT
Thanks so much JGM:  

I am going to take your advice, check out the link that you provided and see
where that takes me.  

If I have any further, more specific questions, I'll be sure to re-post.  

Best Regards - Rod

> RPMitchal was telling us:
> RPMitchal nous racontait que :
[quoted text clipped - 40 lines]
>
> Post back in a new thread with more specific questions.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.