If I use BeforeDoubleclick (below) on a cell in Column A
say a5 (which contains a formula Row()-1), XL thinks I want to edit the
formula throwing me into Edit mode VERSUS running the below code - Also
trying Before RightClick, causes my shortcut menu to come up, probably for
same reason. I need to "turn-off" something here,, but what?


Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Column = 1 Then
Load frmPOReq
With frmPOReq
.txtSeqNo.Value = Target.Value
.txtDate.Value = Target.Offset(0, 1).Value
.txtEmpCode.Value = Target.Offset(0, 2).Value
.txtAmt.Value = Target.Offset(0, 3).Value
End With
End If
End Sub