Can I automatically add user name to excel spreadsheet

[LRL_in_KC]

We have a template to create a form that I would like to have the users name
added to so I can tell who created the form

 

[FSt1]

hi
you could have a macro return the user name
Sub usename()
MsgBox Environ("UserName")
'or
'[A1]=environ("UserName")
End Sub

or you could create a functions to retrun the user name
Public Function UseName()
UseName = Environ("UserName")
End Function

then use the formula on the sheet.....
=UseName()

regards
FSt1