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