time stamping entries
Posted by wdf on February 04, 2002 5:17 PM
Does anyone know how to place date and time w/entry into timesheets
Posted by Jacob on February 04, 2002 5:59 PM
Hi
Lets say you want to place the time in col B in the row where some data was entered then
Sub Worksheet_Change()
Range("B" & Target.Row).FormulaR1C1 = Now
End Sub
HTH
Jacob
Does anyone know how to place date and time w/entry into timesheets
