Check box or radio buttons

Hello,

I created a spreadsheet with the easy-to-use check box function. I see that what this really represents is a TRUE/FALSE value in each cell, which makes sense. Is there any way, with check boxes, to allow only one answer to a question? I know that's technically what a radio button is supposed to do, but the check box feature is much neater.

In the attached example, four businesses are listed and the end-user can select if the business is a client in our region, a client outside of our region, or not a client at all. The ideal would be if only one check box per client can be selected.

Thanks for pointing me in the right direction!

One way would be using VBA.

The below code in the worksheet module would do the trick.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Cells.Count = 1 Then
        If Not Intersect(Target, Range("B:D")) Is Nothing And Target.Row > 2 Then
            Application.EnableEvents = False
            Select Case Target.Column
                Case 2
                    If Target = True Then
                        Cells(Target.Row, 3).Resize(1, 2) = False
                    End If
                Case 3:
                    If Target = True Then
                        Target.Offset(, -1) = False
                        Target.Offset(, 1) = False
                    End If
                Case 4:
                    If Target = True Then
                        Cells(Target.Row, 2).Resize(1, 2) = False
                    End If
            End Select
            Application.EnableEvents = True
        End If
    End If
End Sub

Note: This approach won't work if you're using Excel on a tablet or phone / web version of Excel.

BSB

Thank you both for your quick responses. I haven't learned VBA yet, but it comes up often enough around the forums that perhaps I should take a peek when I have the chance.

I went with 6StringJazzer's solution (solved) based on my skill level, but it for future readers of this thread, maybe BSB's solution would be the right fit.