CheckBox in VBA
try this
ActiveSheet.Shapes("CheckBox2").Select
Selection.Value = False
-----Original Message-----
Hi,
I'm not able to find the right code to use correctly the
checkbox.
It's not working. Here's the part of my code that is not
working.
Worksheets("sheetname").Activate
ActiveSheet.OLEObjects("checkbox2").Object.Valu e = 1
I've tried to place those 2 lines in different places in
my program
and I've also tried to change the name of the ckeckbox
and I still can
not activate this checkbox.
What's the solution?????
.
|