Some day I will actually read the description that OP posts.


Gord

On Wed, 15 Oct 2008 21:05:00 -0700, ShaneDevenshire
wrote:

Hi,

I think you need to try some slightly different code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target = Format(Now, "m/d/yy")
Cancel = True
End Sub

I believe the previous code would have formatted as time not date.