you can use the change event.

right click on the Report sheet tab, select view code and insert code like
this

Private Sub Worksheet_Change( _
ByVal Target As Range)

if Target.Address = "$B$4" then
range("B5").Value = Date
range("B5").NumberFormat:="mm/dd/yyyy"
End if

End Sub

--
Regards,
Tom Ogilvy



"ceemo" wrote:


i would like to add the current date (say cell B5) when the value in
cell B4 is changed from sheets "Report"

Can you help?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=571820