View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Function that will automatically display the User Name?

You'd have to use a VBA function.

Function LogonName() As String
LogonName = Environ("username")
End Function

You can then call this from a cell with

=LogonName()

This will return the user's logon name, not the UserName from the
Options dialog box.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"~C" wrote in message
...
I would like an Excel cell to automaticlly populate a cell with
the computer
user's name. Is this possible?

Thanks!

~C