Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Tally
I know I am reaching here but just wondering - I have a survey that I need to
tally. Is there a formula or a way to set up a cell where I can just click that cell and it will keep adding each time I click on the cell and then give me the total number of times that the cell has been "activated" ? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running Tally
You can have an event macro fire when you select the cell (clicking on it or
using the arrow keys, but coming from a different cell). But how about just adding a button from the Forms toolbar that increments a cell. Option Explicit Sub testme() Dim myCell As Range Set myCell = ActiveSheet.Range("A1") With myCell If IsNumeric(.Value) Then .Value = .Value + 1 End If End With End Sub If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) accessnovice wrote: I know I am reaching here but just wondering - I have a survey that I need to tally. Is there a formula or a way to set up a cell where I can just click that cell and it will keep adding each time I click on the cell and then give me the total number of times that the cell has been "activated" ? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running tally comparing two columns in unsorted list | Excel Discussion (Misc queries) | |||
how to keep a running tally of boxes filled with info | Excel Worksheet Functions | |||
Circular reference error when trying to keep a "running Tally" | Excel Discussion (Misc queries) | |||
formula to keep a running tally of the number of times a certain w | Excel Discussion (Misc queries) | |||
How Excel 2003 Highlight random cells and running tally appear? | Excel Discussion (Misc queries) |