I'm trying to set the values of ActiveX checkboxes that are on a
worksheet.

Here's my code:

For Each ctl In Sheet1.OLEObjects
If TypeOf ctl.Object Is MSForms.CheckBox Then
ctl.Object.Value = True
End If
Next

If I go back and programmatically check the value properties (i.e. in
the Immediate window) they are confirmed as being set to true. The
problem is the checkboxes looks unchecked i.e. there are no ticks!

Anyone know what's going wrong? I'm using Excel2002 and Excel2003
beta.

Thanks.