Auto Date

Right click the sheet tab, select View Code and paste in


then close the code window using the X.

I love it when you use the search function and you find exactly what your after.
Mr.Excel just keeps on rickin' IMHO!

I used this code, and since I have absolutely no clue on code or writing code this was super helpful.
My small problem was I needed this funtion to also happen a few cells accross, but getting the code to do that was almost impossible with no knowledge.
I tried a heap of things and eventually when i worked out what was what i came up with this.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
Application.EnableEvents = False
Target.Offset(0, 1).Value = Date
Application.EnableEvents = True
End If
If Target.Column = 8 Then
Application.EnableEvents = False
Target.Offset(0, 1).Value = Date
Application.EnableEvents = True
End If
End Sub


Now like I said I knwo nothing about code, I used the code from the OP and then tried cutting and pasting a few ways and bingo.
Now I'm not sure if this is how you should add the code, but it works for me.
So thanks VoG II for the original code, cheers mate.
:D

Swanky said:

So thanks VoG II for the original code, cheers mate.
:D

Click to expand...

You are welcome

Your code could actually be shortened somewhat:

Well thanks again VoG, you've been a great help, you may have started my coding adventure.
Will have to get me some books I think.
Thanks mate.
:D

How would one modify this code to include the current (static) time as well as date? I type "time" in a couple of ways but it didn't like it. I know nothing of codes. Thanks for any help.

Change Date to Now.

Thanks Norie, that worked, just what I was looking for. I found another way in another thread: Date + Time. Both seem to work the same; I'm going to use Now because it's simpler. Can anyone comment on the difference between the two? Neither date/time stamp change when I close the file and reopen it,,, so it's acting like a static date/time, they only change(update) on an "enter" from column 1.

Don't you want the date/time to be static?

Yes I do want it to be static - it's the date of receipt.