Perhaps something like this to call each macro separately. Modified to suit
your ranges.
Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
If Target = Range("A1") Then
MyDateStampMacro
Exit Sub
End If
If Target = Range("F1") Then
MyOtherMacro
Exit Sub
End If
End Sub
HTH
Regards,
Howard
"PG Oriel" <PGOriel@discussions.microsoft.com> wrote in message
news:B9CE62F4-152C-48F8-9F94-7C796632D7B5@microsoft.com...
> 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.
Bookmarks