Automatically show new date in the modified cell

I like to add today's date next to the cell value.
Everytime the cell is modified, I want the date to be updated automatically to today's date.

Any help is appreciated.

NYBoy

See

http://www.mcgimpsey.com/excel/timestamp.html


In article <NYBoy.1w6wya_1128114303.6997@excelforum-nospam.com>,
NYBoy <NYBoy.1w6wya_1128114303.6997@excelforum-nospam.com> wrote:

> I like to add today's date next to the cell value.
> Everytime the cell is modified, I want the date to be updated
> automatically to today's date.
>
> Any help is appreciated.
>
> NYBoy

NYBoy, here is one way, this is worksheet code, right click on the worksheet
tab and view code, paste in this code

Private Sub Worksheet_Change(ByVal Target As Range)
'will put the date in column B when data is put in A2:A20
'change range as needed
On Error GoTo E
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A2:A20")) Is Nothing Then
With Target
.Offset(0, 1).Value = Format(Date, "mm/dd/yyyy")
End With
End If

E:
Application.EnableEvents = True
End Sub

You may also want to have a look here for more ways to do it
http://www.mcgimpsey.com/excel/timestamp.html


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"NYBoy" <NYBoy.1w6wya_1128114303.6997@excelforum-nospam.com> wrote in
message news:NYBoy.1w6wya_1128114303.6997@excelforum-nospam.com...
>
> I like to add today's date next to the cell value.
> Everytime the cell is modified, I want the date to be updated
> automatically to today's date.
>
> Any help is appreciated.
>
> NYBoy
>
>
> --
> NYBoy
> ------------------------------------------------------------------------
> NYBoy's Profile:
http://www.excelforum.com/member.php...fo&userid=8360
> View this thread: http://www.excelforum.com/showthread...hreadid=472219
>

Thanks Guys.

Thanks Guys,

How about Timestamping in the same cell in the lower right corner where data is entered.

Am I asking too much?

Thanks,
NYBoy

Did you look at the web page that was cited? What do you want to do
differently?

In article <NYBoy.1wdmmd_1128427505.3907@excelforum-nospam.com>,
NYBoy <NYBoy.1wdmmd_1128427505.3907@excelforum-nospam.com> wrote:

> How about Timestamping in the same cell in the lower right corner where
> data is entered.
>
> Am I asking too much?

Yes, I looked at it. Thanks.
I'm not familiar with codes. I just copied and pasted and it works.

I want to take one step further - I want to know if time stamp date can automatically appear in the same cell where the data is entered.

e.g. If I type the word "Released" in cell C2 and hit enter.

Then the cell C2 appear like this

Released
10/04/05