conditional formula? Unsure of name...

[OC Sadge]

Hi. How do I create boxes that the user can check off, the left box answers 'yes' and the box next to it answers 'no' to whatever item. Once they click yes or no, certain text appears, so if yes is clicked certain text appears in a paragraph and if no then certain text appears in the below paragraph. I also need to create an area off to the side of so that the text appears dependent on the user responses. The user will copy/paste the paragraph into a Word doc. Thank you for any help.

 

[Iktishaf]

You only need a set of check boxes, one for each sentence you wish to control, and then the rest is easy.

So, for each sentence, from the developer tab, choose insert and select Check Box (Form Control). Place the control on the worksheet, say in cell B5. Right click on the check box, select format control, then the control tab, and then place a cell reference, say C5, in the cell link. Now C5 will contain TRUE or FALSE according to whether the check box is selected or not. This value then controls whether the sentence appears in the paragraph. You can hide column C when all your programming is complete.

 

[OC Sadge]

You only need a set of check boxes, one for each sentence you wish to control, and then the rest is easy.

So, for each sentence, from the developer tab, choose insert and select Check Box (Form Control). Place the control on the worksheet, say in cell B5. Right click on the check box, select format control, then the control tab, and then place a cell reference, say C5, in the cell link. Now C5 will contain TRUE or FALSE according to whether the check box is selected or not. This value then controls whether the sentence appears in the paragraph. You can hide column C when all your programming is complete.

Thanks a lot. So now how do I make it so when the box is checked text appears somewhere?

 

[Iktishaf]

Let's say you have three such text boxes, so that you have cell links in C5, C6 and C7. Store the sentences that each control in, say D5 to D7 respectively. Then in the cell that displays your paragraph, write something like

="First part of paragraph"&if(C5,D5,"")&if(C6,D6,"")&if(C7,D7,"")&"Last part of paragraph"

It is better for the user to see the paragraph gradually being generated rather than suddenly being presented with the completed paragraph at the end. The user then has to copy and paste the paragraph to Word.