I have a chekcbox that has transformed into a AutoShape type as in if you run the follwing code you get Type 1: Print ActiveSheet.Shapes("Check Box 5").Type 1
Is there a way to see if it is checked?
I have tried the following codes but they do not work:
ActiveSheet.Shapes("Check Box 5").OLEFormat.Object.Value = 1
ActiveSheet.Shapes("Check Box " & i).ControlFormat.Value = False
Aucun commentaire:
Enregistrer un commentaire