MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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