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.
Private Sub Command1_Click() For Each Control In Me If TypeOf Control Is OptionButton Then Control.Value = False Next End Sub
I want to check them each and link a make a specific cell 1 or 0 when the optioin button is true.
Forum Rules