#1
|
|||
|
|||
Adding up values into one cell with buttons
I have two columns with 2 players and 7 Buttons assigned to each that should add a value of 1 to 7 points to a "Total"-Cell (say B4 and D4) that totals the points (=adds to the previous total) whenever I click the respective Button. I entered the values of 1 to 7 into a (hidden) column (AA), where the respective Buttons could take the values from.
I ended up with a circular reference, whenever I wanted to add a value to the "Total" cell with the formula =B4+AA1 in B4. I thought of a solution to enter the values after each click of a Button into a (hidden) column and use the SUM of this column to be put into the "Total"-Cell, but how will the Macro find the next free Cell in that hidden column...? Thanks a million for any help. |
#2
|
|||
|
|||
Hi,
It may help the members if you attach a copy of the file. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
For Next Loop cell values | grexcelman | Excel Programming | 3 | 03-03-2015 02:56 PM |
Convert non-cell input to cell values | TBD | Excel | 3 | 06-09-2014 06:14 AM |
Sum values within a single cell | shabbaranks | Excel | 17 | 05-13-2014 06:47 PM |
Adding fixed % to different dollar values? | mikehende | Excel | 5 | 03-05-2013 01:50 PM |
Adding a long list of values to a combobox in Word 2003? | ll4u76 | Word VBA | 1 | 04-13-2012 03:37 AM |