Checkboxes and forumulas

[jmc92]

So I just dived into excel today, and I think I've made decent progress.
You can see it here:
https://ufile.io/i8647

What I am trying to do is get the form check boxes (hopefully I can do this dynamically so I don't have to manually set up every check box)
To link to the small navy blue cell right about the bill description. (B1) (I don't care about seeing the true/false)
And when the checkbox is clicked true, the goal is to have the amount in B4, get subtracted off of the total amount in B38. Each check box would effect B38 as a total. And when unchecked, the amount would be added back into B38.

I tried putting a formula such as "=If B1,TRUE-SUM(B38,-B4)" into B1, but it didn't work.
=SUMIF(B1,"TRUE",B38:-B4) Also didn't work.

Also whenever I click the check box, the formula I just put into B1 goes away, which is pretty frustrating.

I tried doing it by macro.

Sub CheckBox_123()

If CheckBoxes("CheckBox123").Value > 1 Then
[B38] = [B38] - [B4]
Else
[B38] = [B37]

End Sub

But yet again...this didn't work either :P
It's nearing 3am..can't google this much further right now lol

 

[Fluff]

Hi & welcome to MrExcel
How about

If ActiveSheet.CheckBoxes(Application.Caller).Value = 1 Then
   [b38] = [b38] - [b4]
Else
   [b38] = [b38] + [b4]
End If

But if you are talking a lot checkboxes there may be other ways of doing what you want.

 

[jmc92]

Hello, thank you for your reply and welcome

Yes, there may be potentially hundreds of checkboxes building up over time. I'm hoping to be able to use the drag/copy handle to extend them further as needed.