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

[Juriaan Borst]

I want to check a couple of hundred optionbuttons and for each optionbutton that's true a particular cell has to become 1 or zero.

How can I do this??

[spandex44]

You could try this.

Create a control array for the option buttons. Once that is done, use this code:

for i = 1 to 300
if option(i).value = true then 'do something
next

I hope this helped. I'm not sure if it'll help.

Alexander McAndrew
VB Zone http://gsenterprise.server101.com