Using check boxes

[john h]

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.

 

[Héctor Miguel]

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.

 

[john h]

Hi Héctor.
Thanks for your reply. I've since thought of an easier solution. I can use a
loop function to count the number of boxes checked in a column(6 or 7) and
display the number in a cell below. I can then just multiply this number by
another from a different cell (no macro required). I just don't know how the
programme recognises if a cell is checked or not. I would be using a check
box from the "forms" toolbar.
John