You could use a Spinner from the Forms Toolbar or worksheet_change event code.

For the event code, see JE McGimpsey's site. Look at the caveats also.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben Excel MVP

On Mon, 25 Apr 2005 18:40:02 -0700, "cbrasted"
wrote:

I want to create a counter, so that every time I click in a certain cell it
takes the existing number and adds "1" to it. Is there any way to do this?
I'm compiling statistical information, and need to get cumulative counts in
various categories as I sort through the data.