I think you don't need a macro for that.
When you press and hold CTRL while selecting cells you
want added with the mouse, Excel shows their sum at the
bottom right corner of the window. You can right click
this section and change it to min, max, average, etc. as
well.
-----Original Message-----
Hi all,
I am very unexperienced so this may sound too easy for
someone, but it'
actually getting on my nerves... Here's the deal:
I'm working on an excel spreadsheet and I want to add a
check box with
a "double" macro that does (when selected) and "un-does"
(when blank)
an operation on a series of numbers.

Say I have these random numbers:

2 5 5
3 4 5
1 9 7

x y z

...where "x, y, z" are the blank cells where I'd like the
result of the
operation to appear.

I want to add a checkbox on each line that, when clicked
on, takes
every number in the line and re-writes it in the "x"
cell, making it
possible to sum it to the others. Say, writing something
like "+A1" in
the "x" cell, "+B1" in the "y" cell and "+C1" in the "z"
cell (where
"A1" is the name of the cell where number 2 is, and so
on).

So if I click on two checkboxes, I will have "+A1+A2" in
the "x" cell,
"+B1+B2" in the "y" cell and "+C1+C2" in the "z" cell.

Can anyone help me??? THANK YOU!


---
Message posted from http://www.ExcelForum.com/

.