hi, john !

I want to have a check box which when checked will take a value from another cell and add it to a total in a third cell.
I also would like to use the same macro connected to more than one check box, doing the same thing.
This is my first attempt at using more than a simple macro & I have no idea how to go about it.

(first:) decide and comment what the correlation is between each element (let's say...)

- how many checkboxes do you need ? (and their corresponding "another" and "third" cells ?)

- when checked "which" checkbox, the macro will take the value from "which" another cell
and will add this value to the total in "which" third cell (???)

- each "third" cell has formulae ? (or hard data in it ?)

- your idea is to use checkboxes from "forms" toolbar, or from (activex) "controls" toolbar ?

- what it is supposed the macro will do every time you "uncheck" any (previously checked) checkbox ?

regards,
hector.