Formula or code to return user name from application

[General Ledger]

Dear All,

Is there a formula that will return the User Name from the setup in Excel or Windows? If no formula, VBA code will do as well.

I am creating a form using Excel 2010. I have a field where I want the name of the current user to appear rather than requiring the user to enter their name. In Excel 2010, the user name is in Excel Options > General > Personalize your copy of Microsoft Office > User name

Happy Holidays to all.

General Ledger

 

[VoG]

In VBA

Application.UserName will return the Excel name.

Environ("username") will return the Windows login name.

 

[General Ledger]

VoG,

Perfect solution once again. Here is my final code:

Private Sub Workbook_Open()
Range("c3") = Application.UserName
End Sub

Thanks,

GL