vba - How to select specific form control checkboxes in Excel? -

I am working in Excel 2010.

I have set up 10 form control checkboxes in my worksheet, and I want to choose a certain group of check boxes automatically. All previous posts which I have seen on this topic, choose all those checkboxes or deselect all checkboxes.

To cancel the selection of all checkboxes, the VBA code from the previous post is here:

  to work as sub clearcheck () in each chess letter in chess Restart the error for the next sh.CheckBoxes.Value = error on the error GoTo 0 Next sh end sub  

Here is the updated code based on this series, but it is still a sentence- With the related problem, running in an unknown sub:

  sub-highengagedonline () Fixed CB checkboxes worth Rs. In the form of sht-like worksheet set sht = worksheet ("article") sht.CheckBoxes for each CB if cb.Name = "check box 35" or _ cb.Name = "check box 36" or _ cb.Name = " Check box 37 "or _ cb.Name =" check box 38 "or _ cb.Name =" check box 39 "then cb.Value = 1 other: cb.Value = 0 ends if the next cb end sub   
 
 
 Try something with that line:  
  sub clear Clear () as the DIB CB checkbox, the sht worksheet set sht = worksheets ("Sheet 1" ) In sht.CheckBoxes, cb.Name = "check box 1" for every CB then cb.Value = 1 Else if cb.Name = "check box 2" then cb.Value = 0 termination if the next CB termination sub