Hey Guys,
I not sure why I'm can't figure this out but I can’t, Help please...
I have several activex controls (checkboxes) in an spreadsheet and I'm trying to change a value of an checkbox to true or checked from another sheet. I've treid the following and several variants thereof:
'.CheckBoxes("CB_" & (Item)).Value = True
.Shapes("CB_" & (Item)).OLEFormat.Object.Value = 1 'Checked
Obviously I'm using an with statement that refers to the workbook and sheet before the call. Either way I cannot seem to affect the checkbox.
Any ideas???
Phil