Conditional Macro

[RPMitchal]

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]

RPMitchal was telling us:
RPMitchal nous racontait que :

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

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.

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[RPMitchal]

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