Excel - Tally routine

[BobJacksonNCI]

I need a macro to help me with a tally task.

I want to react to a keystroke in a specific cell and
add to a counter in another cell based on the
keystroke entered.
For example:
A1 = the target cell.

If 1 is typed, add 1 to C1
If 2 is typed, add 1 to D1
etc

Freeze selection to A1 so I can zip through a bunch of response cards without lifting my right hand from the number pad.

Would someone help, please?
Bob

 

[BobJacksonNCI]

Just did a search and found thread707-773553

But that suggestion uses a mouse click whereas I want to enter a response number and increment the appropriate cell based on the number entered. Shouldn't be that difficult, but my brain is a bit burned out.

Once I understand the code, please point me in the direction of incorporating the code in a worksheet.

Thanks in advance,
Bob

 

[SkipVought]

Hi,

This cannot be done with native Excel functionality.

It however, can be done with VBA code using Worksheet Events. Please post this request in VBA Visual Basic for Applications (Microsoft) Forum707.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}