mardi 20 février 2018

Excel Check-Box see if checked

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