right-click on the sheet tab and choose view code
paste the code below in the VB Editor which opens up
close it and enter anything in A1. the code below will enter the time in B1
everytime A1 changes

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
Range("B1") = Now()
End If
End Sub

"MilleniumPro" wrote:

Hello all,

I have googled around and have not been able to find the answer on the
following:

I am looking to have a cell that automatically populates the current date
and time and leave that information STATIC in that cell once populated when
an adjacent cell has a value entered into it. The only answers I fould were
for excel 2000 and 2003. I am using 2007 and I am totally lost with the new
menu system that has been implemented here. If this requires a macro, please
help me walk through how to enter the area where the macros is to be enter
along with any supporting code. Thanks to anyone in advance that can help.