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):
<tbody>
</tbody>
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
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):
| Question: How likely is this customer to return? | Option Button | Points | Section points: | 4 |
| Answer 1: Very likely | o | 5 | ||
| Answer 2: Somewhat likely | X | 4 | ||
| Answer 3: Neutral | o | 3 | ||
| Answer 4: Somewhat unlikely | o | 2 | ||
| Answer 5: Very unlikely | o | 1 | ||
| Answer 6: Not sure | o | 0 |
<tbody>
</tbody>
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
