Thread: CheckBox in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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?????
.