Get excel to put todays date in and not change it tomorrow 2

[sgburns2000]

I have a log in which people enter a time and the date automatically enters in. The problem is that when it is again viewed the next day, that date that was entered changed. Any way around this?

 

[GlennUK]

How is the date entered exactly?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

Check out
[tt]
ctr+;
[SPACE]
ctr+shift+;
[ENTER]
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[sgburns2000]

I have coded a cell with the following:

=IF(G18>0,TODAY(),"")

So when an entry is made in cell G18, a date is placed in G17. This code is in all of the cells in row 18. It would be great if there is vb code to do this only when the cell in row 18 is changed.

 

[judgeh59]

try this...and of course, there are other ways

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 18 Then
If Cells(Target.Row, Target.Column).Value <> "" Then
Cells(Target.Row, 17).Value = Format(Now(), "mm/dd/yy")
End If
End If

end sub

this must be entered on the worksheet...

Ernest

Be Alert, America needs more lerts

 

[kjv1611]

Did you try Skip's suggestion? No code, no formula, it just works.

That is if you just need to enter the date a field at a time, and do so manually.

Thanks for mentioning those, Skip. I had already forgotten them since they showed up in a favorite shortcuts thread a short while back.

Before that, I had set up my own macro, and assigned it to Ctrl + Q

 

[sgburns2000]

Thanks judgeh59! That did the job.

 

[judgeh59]

Glad I could help...it's my first time

Ernest

Be Alert, America needs more lerts