Each sheet is different howeve it could be columns or something like A1 thru
A10 and then C1 thru C10.
Most of the sheets only have 2 columns that are populated.

Again thanks for your help.

"Don Guillett" wrote:

such as?

--
Don Guillett
SalesAid Software

"Evans" wrote in message
...
Unbelievable.....exactly what I wanted to do. I am not an expert at
coding.
Can this be modified to do ranges of cells?

Again thanks.

"Don Guillett" wrote:

Right click sheet tabview codecopy/paste this.
If you doubleclick cell a5 or a6 the number will increase by 1 for each
double click
You could use a worksheet_selectionchange but it could be dangerous if
you
inadvertently selected.

Private Sub Worksheet_BeforeDoubleClick(ByVal target As Range, Cancel As
Boolean)
If target.Address = "$A$5" Or target.Address = "$A$6" Then
On Error GoTo fixit
Application.EnableEvents = False
If target.Value = 0 Then oldvalue = 0
target.Value = 1 * target.Value + 1
oldvalue = target.Value
fixit:
Application.EnableEvents = True
End If
Cancel = True
End Sub


--
Don Guillett
SalesAid Software

"Evans" wrote in message
...
Does anyone have any experience in using mouse clicks in a cell to
index
numbers, or any experience with voice recognition systems to do this?

We use excel to input numbers from a voice mail system into a form. I
would
like to point to a cell and click it to enter the number one a second
click
would enter 2 and so on. Or better yet use a headset and microphone to
do
all of the entry.