Tomorrows Date - double click

[trevolly]

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

 

[Joe4]

TODAY() is an Excel function, not a VBA one.
The VBA equivalent is DATE().

Sorry I didn't notice it earlier. I just copied over what you had, assuming that you already had that part working.

 

[trevolly]

Thank you so much @Joe4 . My project is complete - everyone on the forum have been absolutely invaluable! Thank you.

 

[Joe4]

You are welcome.