View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Formula returning current user name

You need a VBA UDF

Function UserName()
Username=application.UserName
End Function


and then in the worksheet, use
=UserName()

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TBoeck" wrote in message
...
I'd like to find a way to have a cell automatically display the current

user
name as shown in Tools/Options/General/User name.

Thanks for the help.