UserName in note

[kalatzo]

Hello all,

I could use some help here.
I need a code that can allow the cell to autocreate a note where the name of the user who enteres data will be automatically filled in.

Is there any way to accomplish??


Thanks in advance.

 

[SteveO59L]

this will enter the username in col d, for entries only in col c

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
Target.Offset(0, 1) = Environ("username")
End If
End Sub

 

[kalatzo]

it works perfectly.

thank you vary much.