Macro to record User Name and Duration user accessed file.

Evening Gentlemen,

Could i please get some assistance, creating a macro to record the User Name and date and time, in the first and second cells of each row that have details entered.


A B C D E
1 User Name 22-12-2012 22:10:30 Enter Data Enter Data Enter Data
2 User Name 22-12-2012 22:11:15 Enter Data Enter Data Enter Data
3


Regards

BAJ

It is not clear how you want this to be triggered so I set it to work when there is a change in column C

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Columns("C:C")) Is Nothing Then
    Range("A" & Target.Row).Value = Environ$("Username")
    Range("B" & Target.Row).Value = Now
End If

End Sub