I'm currently working in Excel'10 -
I have set up 10 form control checkboxes in my excel worksheet, and I want to run a macro that automatically selects a certain set of the checkboxes. All of the previous posts that I've seen on this topic cover selecting all checkboxes or unselecting all checkboxes.
Here is the VBA script from a previous post for unselecting all checkboxes:
Sub clearcheck()
Dim sh As Worksheet For Each sh In Sheets
On Error Resume Next
sh.CheckBoxes.Value = False
On Error GoTo 0 Next sh
End Sub
Aucun commentaire:
Enregistrer un commentaire