Radio Buttons Not Grouping

**bobmaucher** · 01-10-2012, 02:42 PM

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

**tigeravatar** · 01-10-2012, 02:48 PM

bobmaucher,

Welcome to the forum!

Does this require radio buttons?
If you're using the sheet directly, i'd suggest using a validation drop down list for each question instead of radio buttons.
If you're using a userform, you can more easily group radio buttons/questions with the Frame control. Each frame would be a question, and then you'd put the desired radio buttons in the frame. (Though I'd still recommend using the sheet directly with data validation drop-down lists)

**martindwilson** · 01-10-2012, 02:48 PM

yes a sample workbook showing what's not working

**bobmaucher** · 01-10-2012, 02:57 PM

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!

**martindwilson** · 01-10-2012, 03:32 PM

the group boxes arent around the buttons you think they are, make all the rows bigger say about 2 inches nothing lines up

**tigeravatar** · 01-10-2012, 04:10 PM

bobmaucher,

Originally Posted by bobmaucher

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

Since you know they'll be "clicking" instead of using a keyboard, and you only want one click per answer, you can use a selection_change event instead of radio buttons. Attached is a modified version of your workbook that does just that. It will put an X in the selected item. Here is the code it uses:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    
    Dim strResult As String
    
    If Target.Cells.Count > 1 Or Intersect(Target, Me.Range("B6:D20,B24:D54")) Is Nothing Then Exit Sub
    
    Application.EnableEvents = False
    If Target.Value = "X" Then strResult = vbNullString Else strResult = "X"
    Intersect(Target.EntireRow, Columns("B:D")).ClearContents
    Target.Value = strResult
    Application.EnableEvents = True
    
End Sub