Clearing Check Boxes automatically

  • Thread starter Thread starter D
  • Start date Start date
D

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
 
For Each ctrl In Controls
If TypeOf ctrl Is CheckBox Then
ctrl.Checkbox1.Value = False
End If
Next ctr
 
Back
Top