need help using a checkbox to determine if a cell gets summed

[Guest]

need help using a checkbox to determine if a cell gets summed. i have
designed a worksheet with items in one column, and how much the item is in
another column. what i want to do is to check a box next to an item and have
the cost of that item added to the other items that are checked. if the item
is unchecked, then resum the items that are checked. i would also like to
add an additional check box that will automatically check or uncheck all of
the other checkboxes. any help will be appreciated.

 

[Guest]

i added the code to a module like the website suggested, i can get it to
create a check box in A1 by running , by running the macro 'addCBX' but that
is it. when i try to run the macro 'MstrCBXClick', i am getting an error of
"Run-time error '1004':
Unable to get the checkboxes property of the worksheet class"
and the line "Set MstrCBX = ActiveSheet.CheckBoxes(Application.Caller)" in
the
'Sub MstrCBXClick()' sub is highlighted. not sure where to go from here.
am i supposed to create the checkboxes manually, if so, in what column? do i
name them anything specific? thanks for looking into this.

 

[Dave Peterson]

You shouldn't be running the MstrCBXClick macro yourself. It's run when you
click the checkbox itself.

 

[Guest]

ok, i found my problem, i wasn't reading your post close enough i guess.
when i read it i thought it said to put the items in a2 to a20, instead of b2
to b20. made the change and it works great. thanks.