Hi,
I have 25 checkboxes in one worksheet. I think it would be
covenient to another checkbox to clear all checkboxes. Can someone
show me how to do that?

Thanks

Ivan

Try this:

Private Sub CheckBox26_Click()
' This works as clear all for other checkboxes 1 t0 25
Dim k as integer
If CheckBox26.Value = False Then ' Checkbox26 is the control checkbox
to clear the other 25
For k = 1 To 25 ' check boxes 1 to 25
Me.Controls("Checkbox" & k).Value =' False set all boxes false
Next k
End If
End Sub

steve:

you have a typo, your apostrophe is before False.

--


Gary


"stevebriz" wrote in message
oups.com...
Try this:

Private Sub CheckBox26_Click()
' This works as clear all for other checkboxes 1 t0 25
Dim k as integer
If CheckBox26.Value = False Then ' Checkbox26 is the control checkbox
to clear the other 25
For k = 1 To 25 ' check boxes 1 to 25
Me.Controls("Checkbox" & k).Value =' False set all boxes false
Next k
End If
End Sub

stevebriz wrote:
Try this:

Private Sub CheckBox26_Click()
' This works as clear all for other checkboxes 1 t0 25
Dim k as integer
If CheckBox26.Value = False Then ' Checkbox26 is the control checkbox
to clear the other 25
For k = 1 To 25 ' check boxes 1 to 25
Me.Controls("Checkbox" & k).Value =' False set all boxes false
Next k
End If
End Sub

Hi Stevebriz,
Thanks a lot for the tip!
I got a syntax error message and this line " Me.Controls("Checkbox" &
k).Value =' False set all boxes false" was highlighted. Do you know
why? Thanks

Ivan

ry I had a typo

replace the line with

Me.Controls("Checkbox" & k).Value = False 'set all boxes false

stevebriz wrote:
ry I had a typo

replace the line with

Me.Controls("Checkbox" & k).Value = False 'set all boxes false

Thanks again!

Now I got another message: "Compile error: Method or Data member not
found."

Thanks.

Ivan

what is the line is the error on?

stevebriz wrote:
what is the line is the error on?

It is the line below with ".Controls" being hightlighted.

Me.Controls("Checkbox" & k).Value = False 'set all boxes false

Thanks

Ivan

If you have the code in a command_click -is the command button you are
clicking on the same form as the checkboxes. or
if the code is checkbox26_click then checkbox26 in the same form as
the other 25 checkboxes?

If you have the code in a command_click -is the command button you are
clicking on the same form as the checkboxes. or
if the code is checkbox26_click then checkbox26 in the same form as
the other 25 checkboxes?

stevebriz wrote:
If you have the code in a command_click -is the command button you are
clicking on the same form as the checkboxes. or
if the code is checkbox26_click then checkbox26 in the same form as
the other 25 checkboxes?

The code is in checkbox26_click. It is the same form as others from
control toolbox.


Ivan

wrote:
stevebriz wrote:
If you have the code in a command_click -is the command button you are
clicking on the same form as the checkboxes. or
if the code is checkbox26_click then checkbox26 in the same form as
the other 25 checkboxes?

The code is in checkbox26_click. It is the same form as others from
control toolbox.


Ivan
If you like you can email me your form and I will have look at it for
you.