Macro to change caption of activeX control checkboxs

[lynnsong986]

Hello, I found this piece of code that should change the label of a checkbox but I got run time error 438 object doesn't support this property or method.
name of the checkbox is "CB10"

Sub ChangeCheckboxCaption() 
ActiveSheet.CheckBoxes("CB10").Caption = "MeteringFee" 
End Sub  

how can I make it work please?

thanks!

[lynnsong986]

sorry I just fixed it, looks like I had too many of them on the sheet and they weren't named properly.