Clearing Check Boxes automatically

[D]

Hi All,

I have a template where users tick numerous Check boxes.
Once done, the data is saved and I want to automatically
clear all tickboxes ("FALSE") before another round. This
is not the VB UserForm but the ordinary Form Check
boxes.

Is there a way to do this automatically from a macro ?

Thanks in advance

D

 

[Vasant Nanavati]

Try:

ActiveSheet.CheckBoxes = False

 

[mudraker]

For Each ctrl In Controls
If TypeOf ctrl Is CheckBox Then
ctrl.Checkbox1.Value = False
End If
Next ctr