need help with a running total

[Quicksnot]

Hi again and ty for taking the time to view my post


have a checkbox in A1 linked to B1, which gives me True or False, in C1 i have this formula =COUNTIF(B1,"TRUE") which gives me a number 1 in C1

i would like a running total in D1 when ever the box is checked.

is that possible?

[ChemistB]

You'll need to assign a macro to the checkbox.
Right click on the checkbox and "Assign Macro">New
The VBA editor will open up with "Sub Checkbox1_Click() or something like that.
Paste this code inbetween the Sub and End Sub

Please Login or Register  to view this content.

That should do it. Does that work for you?

[Quicksnot]

OMG yes thats exactly what i was looking for

i'm new so that just gave me the next step in the program i'm trying to make easier, i have a long way togo though, i am attempting to have an excel program that i can put 18 places, and each place has 6 people that rotate in a pool league, its a program written that works, but takes about 1 hour to find each players name, then type in his amount he won and lost, the whole program is using only =sum, a colum for every week, colum for every win,every loss,table runs,8-ball breaks and its very tiresum

[ChemistB]

Sounds complicated. Good luck. Glad I could help.