Unchecking radio button

[Guest]

I am trying to uncheck radio buttons in Excel. I set them up to be
independent of one another as I have to have the ability to select more than
one under a category. I also need the ability to deselect or uncheck a radio
button if it is mistakenly selected. I tried going under Design Mode, then
Properties, but I do not know what to change. Please help!

 

[Guest]

Oops, I think it's called an Option button, not a radio button.

 

[Bob Phillips]

Same thing

Dim opt As Object
For Each opt In ActiveSheet.OLEObjects
If TypeName(opt.Object) = "OptionButton" Then
opt.Object.Value = False
End If
Next opt


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)