I wanted a cell to automatically put in a date if anything is typed in it...

Example:

if a users puts in a "Y" in A2 .. I want cell A3 to play the date that they
input the "Y"

Is that possible?

Thanks again everyone!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200611/1

Use the change event:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A2")) Is Nothing Then
Else
Range("A3").Value = Now
End If
End Sub

Be sure to put this in worksheet code, not a standard module.
--
Gary's Student


"instereo911 via OfficeKB.com" wrote:

I wanted a cell to automatically put in a date if anything is typed in it...

Example:

if a users puts in a "Y" in A2 .. I want cell A3 to play the date that they
input the "Y"

Is that possible?

Thanks again everyone!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200611/1