About Us

j

Thanks a lot man, this helps out a lot!!!

Josh

"Don Guillett" wrote:

Right click sheet tabview codecopy/paste this. Now, when to double click
any cell in col B, the cell count will increase by 1

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)

If Target.Column < 2 Then Exit Sub
If Target.Count 1 Then Exit Sub
Application.EnableEvents = False
Target.Value = Target + 1
Application.EnableEvents = True
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"J" wrote in message
...
All I've done so far is add a counter using the directions on this
webpage:
http://people.revoledu.com/kardi/tut...Iteration.html

The problem is it creates one manuel counter. You are asked to press
F9 to advance the counter, and it also resets the counter to zero also
using
the
formula, =IF(D3="",B3,IF(B5<B4,B5+1,B3))

I would like to be able to highlight a cell and press a button so that I
can
"add 1"
to the counter.
The problem seems to be that each time I press F9 it counts no matter what
cell I have highlighted, not allowing for more than one counter on a
worksheet because when I put a second counter on the worksheet and pressed
F9
they both counted together.

I am a soccer coach looking for a way for my stat person to be able to
count
different stats during a game by just clicking on a cell and adding 1 on
each
time, for example, a player takes a shot I want the cell counting his
totals
shots to increase by one.
I need this to be quick and easy, to make my stat person's life easier.

Thanks,
Josh

"Don Guillett" wrote:

As always, fully tell us what you are talking about and show what you
have
already done.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"J" wrote in message
...
I have set up a simple manuel counter in a spreadsheet.
It worked just fine, but I need to set up multiple manuel counters
in the same spreadsheet that are independent of each other.
Is there a way to set this up? Also a way to reset
each one of these counters independently?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add A Day Counter	EisPanzer	Excel Discussion (Misc queries)	3	May 9th 07 01:24 AM
counter	Haza	Excel Discussion (Misc queries)	2	January 20th 06 08:30 PM
Counter	Larry Hau	Excel Programming	1	August 14th 03 11:00 PM
Counter	Mark D[_4_]	Excel Programming	0	July 17th 03 12:39 AM
Counter	Don Guillett[_4_]	Excel Programming	0	July 17th 03 12:30 AM

Menu

About Us