When I right click the mouse when it is placed above the button, I get the
Format Control window. However, the control tab does not exist. Can you show
the step by step on how to link the option button?

Thanks

"Luke M" wrote:

If not working as desired now by default, you need to create a group box and
have all your options buttons inside the box. This will force them to only
have 1 of the 4 selected at any one time. Then, go to format control, the
control tab, and in the cell link box, type
=$B$8
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Option Button" wrote:

Let assume I have created 4 option buttons (from the control toolbox) and I
have named them as option1, option 2, option 3, and option 4
Let also assume that option 1 occupies cells D8 to F9, option 2 occupies
cells D12 to F13, option 3 in cells J8 to J9, and option 4 in cells J12 to J13
In cell B8, I want it to be equal to 1 if option 1 is selected, equal to 2
if option 2 is selected, 3 if option 3 is selected and 5 if option 4 is
selected
1. How do I activate an option button so that I can select either option 1,
2, 3 or 4? (If one option is selected, then the rest should be blank)
2. When one of the option is selected, how do assign my cell B8 with the
correct number?