CheckBox in VBA

[Stephane]

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.Value = 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?????

 

[Guest]

try this
ActiveSheet.Shapes("CheckBox2").Select
Selection.Value = False

 

[Bob Phillips]

Works for me. Are you sure it is a control toolbox checkbox?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)