Hi all
Can I ask for some help on this vba code? I'm trying to set up a code for when I double click on a cell it enters tomorrows date (not tomorrow, the 16/09 but whatever the next days date is) This code brings up an error ...... "Compile Error: Ambiguous name detected: Worksheet_BeforeDoubleClick
Cheers all
T
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Date stamp
If Not Intersect(Target, Range("D20")) Is Nothing Then
Cancel = True
Target.Value = Today() + 1
End If
End Sub
Can I ask for some help on this vba code? I'm trying to set up a code for when I double click on a cell it enters tomorrows date (not tomorrow, the 16/09 but whatever the next days date is) This code brings up an error ...... "Compile Error: Ambiguous name detected: Worksheet_BeforeDoubleClick
Cheers all
T
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Date stamp
If Not Intersect(Target, Range("D20")) Is Nothing Then
Cancel = True
Target.Value = Today() + 1
End If
End Sub