Need a click on a cell to truger macro. Please help. Need help urgerntly. Thanks again

[pedie]

When I click on D18, I want C17 formula = now()
then copy and paste special - values in activecell in C17

 

[SteveO59L]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$D$18" Then
Target.Offset(-1, -1) = Date
End If

End Sub

 

[pedie]

Perfect nearly...can it be "9/24/2010 12:00:00 AM" format???

Thanks again that helped alot!

 

[SteveO59L]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$D$18" Then
Target.Offset(-1, -1) = Date & " " & Time
End If

End Sub

 

[pedie]

Steve, thanks alot. Problem solved. Thanks again.