Right now I have a spreadsheet with checkboxes and each one uses the
following code:

Sub SelectYes1()
Range("f6").Value = "=sheet1!b2"
End Sub

All it does is takes a value off sheet1 and then puts it into f6 but
the only problem is, once it is unchecked the value isnt deleted so my
formula bases off of that still includes that number in the total.

Could someone let me know how to construct a macro that could delete
the cell f6 when the checkboxe is unchecked.

Thank you!

-Trevor