mardi 9 mai 2017

Exclude certain checkboxes on FOR EACH checkbox

I have this code that print a value on a cell when all of the checkbox value is true or false

For Each objX In asd.OLEObjects
If TypeName(objX.Object) = "CheckBox" Then
If objX.Object.Value = True Then asd.Range("B10").Value = "aha"
If objX.Object.Value = False Then asd.Range("B11").Value = "good"
End If

What I want to happen is to exclude some of the checkboxes on the above for each statement, how can i do it.

Example: I have 10 checkboxes, i have to checked 7 of it in order to proceed to another task however 3 checkboxes doesnt need to be checked as they have other codes to do.

Appreciate your help guys thanks :)




Aucun commentaire:

Enregistrer un commentaire