search this NG for time stamp
One way is to use the sheets selection change event (
right click the sheet tab to get to its code page)
The following will place a time stamp if cell C2 is
selected...
Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
Dim sText As String
If Target.Address = "$C$2" Then
sText = Format$(Date, "dd-mmm-yy")
sText = sText & " " & Format$(Now, "HH:MM")
Target.Value = sText
End If
End Sub
Patrick Molloy
Microsft Excel MVP
-----Original Message-----
Is there a way to have a cell so that when it is clicked
on or something
it automaticaly enters the date. Probs get it off the
computer clock
or something?
---
Message posted from http://www.ExcelForum.com/
.