Control array

[jpspring]

if i've got a control of say 5 checkboxes and i want to pass all five controls to a sub-procedure to check them all, how would i do this?

test check1()

sub test(chkbox() as checkbox)
end sub

doesn't work, it expects an user-type

 

[Beesknees]

you could try doing this

Dim chk As CheckBox
For Each chk In Me.Controls
Call checkchk(chk)
Next
End Sub


Private Sub checkchk(chk As CheckBox)
MsgBox chk.Value
End Sub

Depending on the value you want to check or change or whatever change the code in the checkchk procedure

 

[jpspring]

what i'm actually trying to do is pass a the whole control array to the sub-routine in one go. Cheers