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.
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.