Add cell value with mouse click
 

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.

Hi!

Maybe you can use a spinner button for this.

Right click any toolbar then select Forms. Click on the spinner button ( it
looks like an up arrow on top of a down arrow).

Place it near the cell you want increment. Once you have it placed and sized
right click on it and select Format Control. Fill in the appropriate values
and you should be good to go. The cell link would be the cell that you want
to increment.

Biff

"cbrasted" wrote in message
...
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.

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.

Biff- This was the perfect solution. Thank you so much. It sure beats doing
it longhand and copying into Excel!

"Biff" wrote:

Hi!

Maybe you can use a spinner button for this.

Right click any toolbar then select Forms. Click on the spinner button ( it
looks like an up arrow on top of a down arrow).

Place it near the cell you want increment. Once you have it placed and sized
right click on it and select Format Control. Fill in the appropriate values
and you should be good to go. The cell link would be the cell that you want
to increment.

Biff

"cbrasted" wrote in message
...
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.

Glad it helped! Thanks for the feedback.

Biff

"cbrasted" wrote in message
...
Biff- This was the perfect solution. Thank you so much. It sure beats
doing
it longhand and copying into Excel!

"Biff" wrote:

Hi!

Maybe you can use a spinner button for this.

Right click any toolbar then select Forms. Click on the spinner button
( it
looks like an up arrow on top of a down arrow).

Place it near the cell you want increment. Once you have it placed and
sized
right click on it and select Format Control. Fill in the appropriate
values
and you should be good to go. The cell link would be the cell that you
want
to increment.

Biff

"cbrasted" wrote in message
...
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.