for i = 1 to 300 optionbutton(i) = false next???

How do I get this working when I have a couple of hundred optionboxes?

Can anyone help??

If you want just to reset all OptionBoxes you could use this:

Code:

---

Private Sub Command1_Click()
    For Each Control In Me
        If TypeOf Control Is OptionButton Then Control.Value = False
    Next
End Sub

---

------------------
Visual Basic Programmer (at least I want to be one)
------------------
PolComSoft
You will hear a lot about it.

I want to check them each and link a make a specific cell 1 or 0 when the optioin button is true.