display date modified instead of value entered

[mieliepap]

I have a spreadsheet which uses visual basic code to display the date that a call was modified. it displays the date in a different cell on the same line. What I would like it to do is display the date instead of the value entered in the cell, for example if i enter "y" into a cell (could be any value) the cell would display the date that this cell was modified instead of the "y".

How the data will be entered [TABLE="width: 500"]
<tbody>[TR]
[TD]project[/TD]
[TD]check 1[/TD]
[TD]check 2[/TD]
[TD]check 3[/TD]
[TD]check 4[/TD]
[TD]check 5[/TD]
[TD]etc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]project a[/TD]
[TD]y[/TD]
[TD]y[/TD]
[TD]y[/TD]
[TD]y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]projects b[/TD]
[TD]y[/TD]
[TD]y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I want it to look like [TABLE="width: 500"]
<tbody>[TR]
[TD]project[/TD]
[TD]check 1[/TD]
[TD]check 2[/TD]
[TD]check 3[/TD]
[TD]check 4[/TD]
[TD]check 5[/TD]
[TD]etc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]project a[/TD]
[TD]25 Dec[/TD]
[TD]2 Jan[/TD]
[TD]21 Jan[/TD]
[TD]25 Jan[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]projects b[/TD]
[TD]14 Jan[/TD]
[TD]25 Jan[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

(these dates would be the dates the "y" (or another value if that's easier) is entered on)
possible?

 

[hippiehacker]

something like this should do

Private Sub Worksheet_Change(ByVal Target As Range)
If UCase(Target) = "Y" Then Target = Format(Now, "dd mmmm")
End Sub

 

[mieliepap]

something like this should do

Private Sub Worksheet_Change(ByVal Target As Range)
If UCase(Target) = "Y" Then Target = Format(Now, "dd mmmm")
End Sub

Thanks, that's exactly what I need.