VBA Export value

I wanted to know if it's possible to export the value or data from checkbox if selected to another sheet?

And If It's possible to make like a yes or no function in a checkbox, for example if the checkbox(yes) is checked The background becomes green, IF the checkbox(No) is checked it becomes orange/yellow, and If the checkbox isn't checked the background becomes red, so it starts red.

This is code objective is to add the column with the checkboxes and The data that was selected in these, checkboxes could it be transfered? And In the same way would it possible to add some type of conditional formation for the color scheme that I presented above.

Sub BoxMaker()
For i = 1 To 4
ActiveSheet.CheckBoxes.Add(358.5, 50, 100, 60).Select
Next

Dim s As Shape
i = 2

For Each s In ActiveSheet.Shapes
s.Top = Cells(i, 1).Top
s.Height = Cells(i, 1).Height
s.Left = Cells(i, 1).Left
s.Width = Cells(i, 1).Width
i = i + 1
Next
End Sub

If you guys need more information I will be glad to give, thanks in advance for any reply.