formulae advice

  • Thread starter Thread starter Kevin J Prince
  • Start date Start date
K

Kevin J Prince

Greetings
Is there a method or function or formulae that can be written to work on
a cell, so that if a value changes (not looked at but actually changes)
will put in a date into another cell?
Regards
 
Hi Kevin

Your question is very general, but I guess "yes" is an unsatisfying answer.
Rightclick the sheet tab, choose "view code", paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)
With Target(1)
If .Column = 2 Then .Offset(0, 2) = Now
End With
End Sub

Now when you enter stuff in B column of this sheet date/time will be entered
in D column.

HTH. best wishes Harald
 
Harald, JEMc|Gimpsey,

Thanks for the answers. Will try them within the hour...

Regards
Kevin
 
Back
Top