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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top