How to reset checkboxes from control tool box?

  • Thread starter Thread starter rottvan
  • Start date Start date
R

rottvan

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
 
stevebriz said:
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
Click to expand...

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 said:
ry I had a typo

replace the line with

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

Thanks again!

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

Thanks.

Ivan
 
stevebriz said:
what is the line is the error on?
Click to expand...

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 said:
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?
Click to expand...

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


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


Ivan
Click to expand...
If you like you can email me your form and I will have look at it for
you.
 
Back
Top