This should be simple right?
I've inserted an ActiveXControl Checkbox into my spreadsheet -it's definitely an ActiveX one & not a form one as I've checked several times & even added a form one just to make sure they were different.
I now want to use it in my code, but just can't get it working!!
This:
gives the response: Object doesn't support this property or method
& this:
gives the response: Object required
How do I refer to it? I used the Properties box to change the (name) category to cb_Cash_Y & I've, again, checked multiple times I'm using the correct name.
Thanks
I've inserted an ActiveXControl Checkbox into my spreadsheet -it's definitely an ActiveX one & not a form one as I've checked several times & even added a form one just to make sure they were different.
I now want to use it in my code, but just can't get it working!!
This:
Code:
If ActiveSheet.CheckBox("cb_Cash_Y").Value = True Then
gives the response: Object doesn't support this property or method
& this:
Code:
If cb_Cash_Y.Value = True Then
gives the response: Object required
How do I refer to it? I used the Properties box to change the (name) category to cb_Cash_Y & I've, again, checked multiple times I'm using the correct name.
Thanks