Option buttons that then can be used in a formula

[texaschai]

Hello everyone,
While I know how to use option buttons in the Developer tab under Form Controls, I am new to the ones in ActiveX. I believe I need to use the ActiveX ones, based on the following criteria, but correct me if I'm wrong:
1. I have 5 sections on the same "survey" form (one page) that require radio buttons (only one answer allowed per section).
2. Within each section there are 6 possible answers. Each answer is allotted a point value (between 0 and 5 points) depending on their answer.
3. To the right of each section, I have a box that says "Points" which is supposed to put in the point value of the one answer selected in each section. (It looks something like this where the X is acting as a selected option button):
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Question: How likely is this customer to return?[/TD]
[TD]Option Button[/TD]
[TD]Points[/TD]
[TD]Section points: [/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Answer 1: Very likely[/TD]
[TD]o[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Answer 2: Somewhat likely[/TD]
[TD]X[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Answer 3: Neutral[/TD]
[TD]o[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Answer 4: Somewhat unlikely[/TD]
[TD]o[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Answer 5: Very unlikely[/TD]
[TD]o[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Answer 6: Not sure[/TD]
[TD]o[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]












The problem I'm having is that when I use Form Controls option buttons, I can only select one radio button on the entire form, instead of one answer in each section (because they are option buttons, and only one button can be selected). I liked the ease of Form Controls other than that snag because of the fact that I could give each button a value, and when the value changed in a specific cell based on which one was selected, my Section Points formula would return the correct value as the option button selected. However, since it's only letting me select ONE option button for the entire page, not just that section, I switched to ActiveX option button so I could name each section of the page as its own grouping and have them act as independent groups of option buttons. However, now I can't get the formula to work. I'm new to ActiveX so I don't know how to make a formula that says "if Answer 5's button is checked, the value should be 1 point". I really don't want to use VBA if possible. So is there a way to make the Form Control buttons group together? I tried grouping them together into sub-groups of buttons but it will still only allow me to select one button per entire page.
Thanks!
Texaschai

 

[AlphaFrog]

So is there a way to make the Form Control buttons group together?

There is a Form control Group Box (or Frame)
Add a group box or frame control to a worksheet

Put a Group Box on the worksheet and the option buttons within the Group Box.

Option Buttons on the worksheet not in a Group Box belong to their own group.

 

[texaschai]

Sorry, where and how do I do that? And will I have to format them a certain way (some of my answers are left to right instead of stacked in a top-to-bottom row with the buttons on the right)?

 

[AlphaFrog]

Sorry, where and how do I do that? And will I have to format them a certain way (some of my answers are left to right instead of stacked in a top-to-bottom row with the buttons on the right)?

Click on the link for instructions.

 

[texaschai]

I should add this question: Can I add the form control box around pre-existing buttons? Or do I have to scrap my work and start over once I insert the control box?

 

[texaschai]

Thank you. It is very helpful. I am just hoping I don't have to start over with inserting all the buttons!