ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,699
- Office Version
- 2007
- Platform
- Windows
Morning,
My current range is S4 & down the page.
I wish to double click a cell in column A to then add the value DEL in column S on that same row.
So if the user double clicks in cell A27 the value DEL should be entered in cell S27
Same for cell A123 then S123 should also have DEL entered into it
I have this below but stuck with the adding of DEL in the cell.
My current range is S4 & down the page.
I wish to double click a cell in column A to then add the value DEL in column S on that same row.
So if the user double clicks in cell A27 the value DEL should be entered in cell S27
Same for cell A123 then S123 should also have DEL entered into it
I have this below but stuck with the adding of DEL in the cell.
Rich (BB code):
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Range("S4", Cells(Rows.Count, "S").End(xlUp)), Target) Is Nothing Then
Cancel = True
Active.Row.Value = ("DEL")
End If
End Sub