Thanks Chip

I got around it by using the 'BeforeRightClick' for a
second date on sheet. Bit daggy but it's for personal use
only.

Regards Bob C.


-----Original Message-----
Robert,

No, you cannot have more than one event procedure for an
event.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Robert Christie"
wrote in
message ...
Hi Again JE

Is it possible to have more than 2

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

in the same sheet.
I tried adding '_two' after DoubleClick and changing
cell
references but it did not work.

TIA

Regards Bob C.


-----Original Message-----
You can set the Cancel property to True instead
of "moving the cursor":

Private Sub Worksheet_BeforeDoubleClick( _
ByVal Target As Range, Cancel As Boolean)
With Target
If .Address(False, False) = "B2" Then
Cancel = True
If IsNumeric(Range("E2").Value) Then _
.Value = .Value + Int(Range
("E2").Value)
End If
End With
End Sub



In article ,
"Robert Christie"

wrote:

I added a Range("??").Select line of code before the
End
Sub last line to move curser to a 'neutral corner'
as
a
safety measure and to be able to doubleclick the
Cell
A1
again. As you know Doubleclicking a cell allows you
to
edit in the cell.
.



.