LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default adding numbers macro

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding different numbers jaywizz Excel Discussion (Misc queries) 3 May 29th 08 06:17 PM
Adding numbers computerkiller Excel Discussion (Misc queries) 1 May 28th 08 03:05 AM
Adding numbers or characters to existing numbers Jannie Excel Worksheet Functions 9 February 20th 07 03:08 PM
Macro Adding Numbers in Column A + B = C Sam Excel Discussion (Misc queries) 8 October 26th 06 09:43 PM
Adding numbers to current numbers mk Excel Worksheet Functions 2 May 16th 05 11:25 PM


All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"