How to show current user name in a cell

Question

In most of the online resource I can find usually show me how to retrieve this information in VBA  Is there any direct way to get this information in a cell   For example as simple as  ENVIRON  User    which did not work

User · Answer

Without VBA macro  you can use this tips to get the username from the path     MID INFO  DIRECTORY   10 LEN INFO  DIRECTORY   -LEN MID INFO  DIRECTORY   FIND     INFO  DIRECTORY   10  1000  -LEN  C  Users

User · Answer

The simplest way is to create a VBA macro that wraps that function  like so   Function UserNameWindows   As String     UserName   Environ  USERNAME   End Function   Then call it from the cell    UserNameWindows     See this article for more details  and other ways

User · Answer

Based on the instructions at the link below  do the following   In VBA insert a new module and paste in this code   Public Function UserName       UserName   Environ   UserName   End Function   Call the function using the formula    Username     Based on instructions at   https   support office com en-us article Create-Custom-Functions-in-Excel-2007-2f06c10b-3622-40d6-a1b2-b6748ae8231f

User · Answer

Example  to view the Windows User Name on Cell C5  you can use this script    Range  C5   Value         amp  Environ  USERNAME

User · Answer

This displays the name of the current user   Function Username   As String     Username   Application Username End Function   The property Application Username holds the name entered with the installation of MS Office   Enter this formula in a cell    Username

User · Answer

if you don t want to create a UDF in VBA or you can t  this could be an alternative    Cell  Filename  A1  this will give you the full file name  and from this you could get the user name with something like this    Mid A1 Find     A1 4  1 Find     A1 Find     A1 4  -2     This Formula runs only from a workbook saved earlier   You must start from 4th position because of the first slash from the drive

[excel] How to show current user name in a cell?

Examples related to excel

Examples related to vba

Examples related to excel-2003

Examples related to worksheet-function