Hi, jaskamakkara,
you might use Class programming to do so. But I suggest to have a look at the events BeforeDoubleClick and BeforeRightClick behind the sheet which may reduce the programming as the codes go behind teh sheet (sample is for Column 3 = C starting at row 3):
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With Target
If .Column = 3 And .Row > 2 Then
With .Offset(0, -1)
If IsNumeric(.Value) Then
.Value = .Value - 1
Cancel = True
End If
End With
End If
End With
End Sub
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
With Target
If .Column = 3 And .Row > 2 Then
With .Offset(0, -1)
If IsNumeric(.Value) Then
.Value = .Value + 1
Cancel = True
End If
End With
End If
End With
Ciao,
Holger
Bookmarks