Hi,

Revise Jim's code as follows:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)

Cancel = True
If Target.Row = 1 Then
Target = Date
Else
Select Case Target
Case Empty
Target.Value = "x"
Case "x"
Target.Value = "xx"
Case "xx"
Target.Value = 15
End Select
End If

End Sub

Regards,
GS

"PG Oriel" wrote:

Hi...

I have been given some advice to use a double click event to change my cells
contents which works brilliantly.

Is there a way to get another double click event to work for some specific
cells in the same sheet's code? Such as the inserting the day's date into a
cell in the top row when I double click? ... Whilst ensuring the remaining
cells do another double click event??

Thanks.