How do you uncheck a radio button in a group?

[squeakums]

I'm trying to figure out how you uncheck a radio button in a group. It is always showing one button dotted in each group and I cannot just make the boxes blank until checked.

An example of this is:

(Check Box) Yes (Check Box) No (Check Box) N/A

Let me know if this is possible through a macro on the button or through its properties in design mode?

Thanks. :wink:

 

[onlyadrafter]

Hello,

Is it an option button from the FORMS or the CONTROL TOOLBOX toolbar?

 

[squeakums]

It is part of the controls toolbar.

 

[squeakums]

Can it be done?

 

[Datsmart]

This code will uncheck all option buttons on the active sheet.

Sub UncheckOB()
Dim i As Integer
Dim shapecount As Integer
    shapecount = ActiveSheet.Shapes.Count
    On Error Resume Next
    For i = 1 To shapecount
        ActiveSheet.OLEObjects("OptionButton" & i).Object.Value = False 'True
    Next i
End Sub

 

[squeakums]

Do I have to use this formula for each option button? Or, can I go into properties and change in there easier? I have a lot of option buttons lol. Thanks!

 

[Datsmart]

There is no formula. This is VBA (macro) code.
Did you run it?
Like I said earlier, when run, it will uncheck all option buttons on the active worksheet.
Yes, you will have to run it after the option buttons have been changed, but it will un-check them as you asked.

 

[squeakums]

Wow it works!! John you are awesome!! I should be paying you for this lol.