Tally Strokes / Command Button / Macro

  • Thread starter Thread starter BusterMcT
  • Start date Start date
B

BusterMcT

Greetings:

I need assistance with a macro. I need to create a tally sheet in Excel
using information from a survey that was returned to me by fax. Here
is what I'm tiring to accomplish.

I have created two sections in the spreadsheet. One titled
"Responses" and the second titled "Tally Strokes." Each cell in
the Responses has a corresponding cell in "Tally Strokes." I have a
command button in each cell of the Tally Strokes section. I would like
the total that is stored in the "Responses" cell to increase by one
each time the command button is clicked in the corresponding cell under
Tally Marks.

I have the most basic of knowledge with these macros so your assistance
is greatly appreciated.

Terry
 
Terry,

Some possibilities. To increment a cell:
Range("A1") = Range("A1") + 1

You don't say what the physical relationship between the Responses and Tally
Strokes sections is, so I can't be more specific. Also, consider a single
macro, in which you select the cell of interest, then the macro figures out
where the corresponding cell is and increments it. You'd only need one
macro, and wouldn't need a bunch of buttons. The macro could be activated
by a toolbar button, keyboard shortcut, etc.
 
Back
Top