I have a list of names with checkboxes next to them. I want to add up all
the checkboxes that are ticked. Approx 100 lines.

I have not linked them already to a cell and don't want to change the code
for every cell individually.

Is there a quick way to do this?

Thanks very much