Tally Strokes / Command Button / Macro

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
 
E

Earl Kiosterud

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.
 
B

BusterMcT

Hi Earl:

Basically, a survey was created in Excel. It was faxed to participants
and they checked off their responses and returned the document via fax.
I would like to use the original Excel Spreadsheet to record the
responses from all of the participants. I created the "Tally Mark"
section so as I reviewed each sheet I would simply click and record the
responses to each question.

Example:
Question Responses Tally Marks
Your eye color? Red | Green | Blue Red | Green | Blue
4 2 5 ||||| ||||| |||||
Hair Color? Brown | Black | Blonde Brown | Black | Blonde
5 3 4 ||||| ||||| |||||

(|||||) = Control Button

Basically each of the "Responses" would start with a base of
"0." I will review each survey and record their response by
clicking on the corresponding control button in "Tally Marks." Once
I click on the control button I would like the number in the Responses
area to increase by 1. I will be logging responses from about 100
surveys. So in the end the response sections should look something
like...

Your eye color? Red | Green | Blue Red | Green | Blue
65 12 23 ||||| ||||| |||||
Hair Color? Brown | Black | Blonde Brown | Black | Blonde
15 37 48 ||||| ||||| |||||

Thanks for your assist.

Terry
 
Top