Hello all,



I'm hoping someone can help as I'm a beginner with word and excel. I am trying to create a word or excel document that has questions, which if marked yes/no, will generate continuous text in a field below. There are numerous questions with multiple parts.

Example:

Topic 1: Assessment Completion:

Did you complete your assessment?
A.) Yes
B.) Partially
C.) No

Was your assessment completed correctly?
D.) Yes
E.) No

[Text field generated for Topic 1]


Topic 2: Scheduling:

Did you complete your schedule?
A.) Yes
B.) Partially
C.) No

Was your schedule completed correctly?
D.) Yes
E.) No

[Text field generated for Topic 2]



****Text to generate for Topic 1***

If A.) is selected generate text stating "Great job completing your assessment in a timely manner."

If B.) is selected generate text stating "Your assessments are inconsistent, please work on completing thoroughly."

If C.) is selected generate text stating "You must complete your assessments in a timely manner"

If D.) is selected generate text stating "Your assessment was correct"

If E.) is selected generate text stating "However, your assessment was not completed correctly"


****Example Text Field for Topic 1 would display****

Based on selections A, E:

"Great job completing your assessment in a timely manner. However, your assessment was not completed correctly."


If anyone can help or create a sample document, I would be forever in debt!!! Thank you for any assistance!!!

Attached is a sample document done with mapped content controls. For this demo I've used built-in metadata fields - if you have a lot of these then you would need to embed a custom xml since you will run out of built-in fields quickly.

If you don't want to use mapped content controls, you would need to use macros to populate the secondary content controls. Code for that can be seen in various threads here including most recently this one https://www.msofficeforums.com/word-...-dropdown.html

Attached Files

Demo_MappedCCs_dropdown2.docx (28.7 KB, 2 views)

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

You are my hero!!! Thank you so much! I do have many, many fields so let me look into the link you provided. Thank you for the starting point!