Is it possible to use one check box to select all other check boxes, i would like a select all option.. any ideas.?
Many thanks
Printable View
Is it possible to use one check box to select all other check boxes, i would like a select all option.. any ideas.?
Many thanks
It's easy when all your checkboxes got the same name, just diffenent indices (chkOptions(0),chkOptions(1),... ).
hope this helps!Code:Private Sub chkAll_Click()
Dim i, number_of_options As Integer
number_of_options = 8
If chkAll.Value = vbChecked Then
For i = 0 To (number_of_options - 1)
chkOptions(i).Value = vbChecked
Next i
End If
End Sub
No they have'nt each check box is different, can my check boxes return a string.?
can not catch you try to describe.
What do you aspect the CheckBox return to your application?Quote:
No they have'nt each check box is different, can my check boxes return a string.?
Here's the scenario:
cust1 (check box)
cust2 (check box)
etc
I would like the check box if checked return a string value.. is there a better way then...
if cust1 = 1 then
tstring = "whatever"
end if