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

Bob,

Thank you for the help. Just one last question (can ya tell I'm new?), what
is a "VBA UDF"

"Bob Phillips" wrote:

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.