Deselecting ActiveX Option Buttons

[BrianFawcett]

I have developed a form in Excel that is being used as an Order Form.

On the form I have a series of groups of Option Buttons set up so the user can only select one from each group.

The issue I am having is that once the user chooses one of the options, they cannot deselect them all, they have to choose one.

Is there a way to set up the Option Button groups so that user can deselect all of the options in the group?

 

[boblarson]

If you didn't change their names, then this should work but you might need to change their names to include OptionButton:

Dim ctl As Control
For Each ctl In Me.Controls
    If InStr(1, ctl.Name, "OptionButton") > 0 Then
        ctl.Value = False
    End If
Next