That's closer than I've been, but there could be many people attending the
event. When actions occur that would accumulate points, I want the person
handling this to be able to click one button and add the points to all those
with the box checked. This would allow them to only have to check and uncheck
boxes at other times when people come and go.
Maybe the checkbox isn't the answer. I just want to make it simple, as the
person doing this will have other duties as well.

"JLGWhiz" wrote:

Why not just put some code in the Checkbox control that adds the points?
Something similar to this psuedo code snippet.

Private Sub Checkbox1_Click()
Dim SomeCell As Range
SomeCell = Range("B6")
If Checkbox1.Value = True Then
SomeCell = SomeCell.Value + 5
End If
Checkbox1.Value = False
End Sub

The principle of the above code is to assign a variable to the cell where
the persons points will be accumulated. As the person clicks the checkbox
that they attended the event, or a session of the event, then the points are
added to the accumulator cell, in this case B6. The checkbox then resets to
False, or empty.