Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 wit 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 th operation to appear. I want to add a checkbox on each line that, when clicked on, take every number in the line and re-writes it in the "x" cell, making i possible to sum it to the others. Say, writing something like "+A1" i the "x" cell, "+B1" in the "y" cell and "+C1" in the "z" cell (wher "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding different numbers | Excel Discussion (Misc queries) | |||
Adding numbers | Excel Discussion (Misc queries) | |||
Adding numbers or characters to existing numbers | Excel Worksheet Functions | |||
Macro Adding Numbers in Column A + B = C | Excel Discussion (Misc queries) | |||
Adding numbers to current numbers | Excel Worksheet Functions |