View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
yo beee yo beee is offline
external usenet poster
 
Posts: 15
Default Current time Current date.

It worked like a charm. Thanks a mil'. Genius, you are!!! Kind, as well, to
help someone out. It is much appreciated.
yo beee
"Norman Jones" wrote in message
...
Hi Yo Beee

Try:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count 1 Then Exit Sub
If .Column = 3 And .Row 8 Then
.Offset(0, -1).Value = Time()
.Offset(0, -2).Value = Date
End If
End With
End Sub


---
Regards,
Norman


"yo beee" wrote in message
...
Paul,

Thanks for the help and the code worked fine. Now, I just need to tweak

it
a
bit. I thought I could figure it out on my own but I am at a loss. So,

here
is specifically what I need to do. At cell C9, I will add a line of text

and
hit enter. I need the current date to be entered into A9 and the time to

be
entered into B9. A few moments later I will add a line of text into C10,

and
I need the exact date to be filled into cell A10 and the time into B10,

and
so on and so on, and so. But I only need this to start on line 9 and

down
from there. Hopefully, you can help me.