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

project	check 1	check 2	check 3	check 4	check 5	etc
project a	y	y	y	y
projects b	y	y

<tbody>
</tbody>

What I want it to look like

project	check 1	check 2	check 3	check 4	check 5	etc
project a	25 Dec	2 Jan	21 Jan	25 Jan
projects b	14 Jan	25 Jan

<tbody>
</tbody>

(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.