conditional formula? Unsure of name...

OC Sadge

New Member
Joined
May 9, 2013
Messages
2
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.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Iktishaf

Board Regular
Joined
Dec 21, 2012
Messages
73
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

New Member
Joined
May 9, 2013
Messages
2
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

Board Regular
Joined
Dec 21, 2012
Messages
73
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,307
Messages
5,600,869
Members
414,411
Latest member
Snowmanaus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top