Operaing checkboxes

[traps]

Here's what I'm tyring to do and it's driving me nuts!

I would llike to be able to check off boxes in "column A" which would add up corresponding values in "Column B"

For example:

I would check off boxes A1, A2, A3, and that would automatically ADD the values in B1, B2, B3. Depending on what boxes I check off it sould add the corresponding values.

I'm would like to use this to construct a "quote helper" so I can easily give quotes by simple clicking of certain boxes.

Is this possible? Any help would be greatly appreciated.

Thanks.

[ForSale]

I hope no one else reads this, as this is probably a really bad way to do this, but try this.
checkboxes in row A, prices in row B, in D1 put =sum(c1:c?)

Private Sub CheckBox1_Click()
If Sheet1.CheckBox1.Value = True Then
Sheet1.Range("c1").Value = "=b1"
ElseIf Sheet1.CheckBox1.Value = False Then
Sheet1.Range("c1").Value = ""
End If
End Sub

Private Sub CheckBox2_Click()
If Sheet1.CheckBox2.Value = True Then
Sheet1.Range("c2").Value = "=b2"
ElseIf Sheet1.CheckBox2.Value = False Then
Sheet1.Range("c2").Value = ""
End If
End Sub

Private Sub CheckBox3_Click()
If Sheet1.CheckBox3.Value = True Then
Sheet1.Range("c3").Value = "=b3"
ElseIf Sheet..CheckBox3.Value = False Then
Sheet1.Range("c3").Value = ""
End If
End Sub

sorry i couldn't come up with anything better.