Radio Buttons Not Grouping

Hi,

I've been struggling with this issue for a few days, and I'm hoping the experts here can solve it for me.

I'm building a spreadsheet that contains 20 - 30 questions about the condition of a home.

For example, "Paint" would be classified as one of the following: "OK", "Needs Touch Up", or "New Paint Job".
Same thing for "Carpet", "Appliances", and so on.

I'm using radio button forms for each option, and using the control group to bunch them separately.

The first three or four work as I would expect.

Below that, the groupings don't seem to serve their purpose. In any of the next 20 questions, the option buttons function as if there is no grouping whatsoever. When in reality, each group is separated by a box. But I can only select one option of all the groups. It should be one PER group.

Does that make sense? Any thoughts? Any other information you'd need to solve this problem?


Thanks very much!!

Thanks, tigeravatar!

Does it require radio buttons? No. But someone will be using this form repeatedly (on an iPad), and I'm looking to minimize the number of times they touch it. It's just in the interest of efficiency. Radio button would require one "click", and validation drop down list would require two. Such a small difference, I know - but I'm just looking to make it as easy to use and efficient as possible. If you think the radio buttons really mess it up, then I'd consider getting rid of them.

I am not using a userform, although I will consider it. Thanks for that suggestion. Best case, I can fix these option buttons. But if not, that's likely the way I'll go.

Attached is a sample of what I'm trying to do. There will be formulas that calculate cost, based on which options are selected.
Property Checklist Template.xlsm


Thanks again!

I am creating a checklist which has multiple plates and items to be considered for each plate. Each item is either “Required” or “N/A” for each plate. I have used the above macro but I can only manipulate the macro to work for one Plate. I would like for each plate used to have its own separate change selection (check box) for each item. What am I doing wrong here?
Please let me know if you need any additional information.

new to this whole site and figuring out how to attach my document.. Please stay tuned....

To expand a little from my post above. I currently have Columns V and W Rows 41-49 and 55-99, as a check box "Selection Change", macro from tigeravatar above. I would like Y:Z, AB:AC, AE:AF, AH:AI, AK:AL and AN:AO to have their own set of check box (selections). I like the selection change as you can only select one or the other and would like to continue that for the additional Plates found in Row 32 (V, Y, AB, AE, AH, AK and AN). I plan on adding in a formula where if any of these plates/items are selected, each topic (found in column AR) must have either "Required" or "N/A" selected. If it makes more sense to structure the spreadsheet differently, I am open to suggestions. I used to be involved in the excel community but I have not used macros/VBAs for about 9 years now and I am a little out of shape.