Quote:
Originally Posted by dbs179
Fumei,
Thank you for the response. Yes the logic is clear and the same every time. Also the responses are boilerplate, I will have analysts reviewing the response documents prior to them being sent back, but at least if I can get this to part to work, they are only massaging the boilerplate language that is there. Also the check boxes are legacy form field boxes.
So could you give me a quick example or sample of code, and possibly explain how I would link the two documents, where I would put the code (I'm thinking it would have to be in document C).
Thanks so much, I do appreciate the help. Like you I have a total of about 9800 of these to do. I didn't pick the format to send them out in either, or I would have recommended/researched out a better option prior to starting the project.
Thanks,
Dave
|
You could store your variable language in AutoText in your template.
Each checkbox should be assigned a bookmark name. Your code tests for its value, and based on the value inserts code.
See Doug Robbins' answer in
this thread for sample vba code for an on-exit macro for your checkboxes.
http://social.technet.microsoft.com/...do-not-display
Rather than a protected form or in addition to it you might want to consider using a UserForm which has the advantage of not needing to have your checkboxes in the final document.
Create a Simple Userform
Create & Employ a Userform