Tally Counter

[mlsmcc]

Excuse my ignorance...

I am looking to create a tally counter in excel with 26 banks/columns (B2:B13 and D2:D13) controlled by the "Esc" through "F12" keys and the "~" through "=" keys.

I have tried inserting an activex check box and setting the true value to initiate SendKeys.Send("^"). Then set the OnKey of "^{Esc}" for example to "B2=B2+1".

Did not work...so I was hoping someone could point me in the right direction or let me know if this is even possible.

Thank you in advance!

 

[Scott Huish]

A couple things, first that range is a total of 24 cells, not 26. It is also in 2 columns.

How are you trying to increment the cells exactly? Why not just use the double click event to control the incrementation?

 

[mlsmcc]

A couple things, first that range is a total of 24 cells, not 26. It is also in 2 columns.

How are you trying to increment the cells exactly? Why not just use the double click event to control the incrementation?

1) That is correct...the range would actually be in columns B:N and rows 2 and 4.

2a) I would like to increment the cells using the keyboard keys. (i.e. Pressing "Esc" or "Cntrl+Esc" increments B2+1)

2b) The mouse would be useless as in some cases the tally keys will have to be pressed in a fast sequence.

 

[mlsmcc]

@HOTPEPPER
Forgot to say thanks for the reply...