Checkbox Objects and Variables 1

[neiljabba]

Hello folks

Ive been trying to reduce my code length using a variable assigned to a checkbox object e.g.

CheckBoxa.Value

where "a" is a loop counter but keep getting object not defined errors. I understand why but is there a method I can use to allow me to write the same code for 30 boxes and loop it.

 

[TonyJollans]

Hi neiljabba,

Checkboxes are controls on your form. Assuming yours are called CheckBox1, CheckBox2, etc., you can usesomething like:

For a = 1 to 30
    If Me.Controls("CheckBox" & a).Value = True Then

' Do what you want here

    End If
Next

If they have more varied names then you can loop through all the controls and, for each that is a checkbox, do whatever you want. Post back if code for that would help.

Enjoy,
Tony

 

[neiljabba]

Cheers Tony Ill give it a go