lundi 16 mars 2015

How to set a macro to select specific form control checkboxes in excel?

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