Trying to Associate Text Strings with Option Buttons

[Nailgunn]

Hi, I have been tasked with providing my team with either 1) text that states there is no contract in place so our terms and conditions would apply or 2) A GSA is in place and the terms of that agreement will be used.

I feel like option buttons are the way to go because that leaves only ONE option for the user to select. I read where I can use the Cell Link box with an If statement I guess. Sorry, I normally work with Word! My problem is the examples I have seen have 10 or 12 characters whereas I have one option that is several sentences long. I thought that I could use a reference like Terms or GSA and then somehow have those words linked to the actual sentences that apply to one of the two option buttons but all I have done is create confusion for myself.

I am working on a worksheet that was created by someone else and I just placed the option buttons in cells A7 and A8 with the text strings in the adjacent columns. After that, I tried to do an if statement but I cannot type all the text because it's too long. What I thought would happen was if Option 1 was selected, Option 2 would disappear or vice versa.

Does this make any sense at all, what I am trying to do? If so, is there someone that can point me in the right direction so I don't pull out all my hair!
Thank you in advance for any guidance.

 

[Norie]

You can link both option buttons with the same cell, you could then use that cell to determine which set of text to use.

For example if you link both option buttons to A1 you could use this formula to return the appropriate text.

=IF(A1=1, C7, C8)

 

[Nailgunn]

Thank you I appreciate your reply. I will try this. I guess I can put that text in a cell that is normally not seen but then I have to let the user know which one is which because my end goal is to not have the entire wording on the one that wasn't selected. So if I clicked on the button by "Terms" it would place all that text in and the row where "GSA" is would be blank except for column B. Is this possible?
Thanks