CheckBox in VBA

S

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?????
 
B

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)
 
Top