Choosing checkboxes in another column

I am trying to use this code that I found somewhere online for linking my checkboxes to another cell

Sub CheckboxValue_Method1() Dim cbValue As Long cbValue = ActiveSheet.Shapes("Check Box 1").ControlFormat.Value End Sub

This works perfectley as long as I have just one column of checkboxes. If I want to use the same code for choosing the checkboxes on second column how should I edit the code? I don't want to use a Master checkbox.