Formula returning current user name

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.

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" <TBoeck@discussions.microsoft.com> wrote in message
news:8E2E4FED-E159-498C-A694-BE2F330B6153@microsoft.com...
> 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.

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" <TBoeck@discussions.microsoft.com> wrote in message
> news:8E2E4FED-E159-498C-A694-BE2F330B6153@microsoft.com...
> > 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.
>
>
>

Essentially it is a macro that you can call directly from the worksheet, as
it it were a function (UDF - User Defined Function). To create it, in Excel
Alt-F11 will take you into the VBIDE. In the menu, select Insert>Module,
then just copy that code into there. Then close the VBIDE.

BTW, you can also get the login name which is a bit more reliable than the
application name, as the user cannot change it. The VBA for that is

Function UserName()
UserName = Environ("UserName")
End Function

--

HTH

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


"TBoeck" <TBoeck@discussions.microsoft.com> wrote in message
news:821E42CA-B0FF-4E55-8608-9557A0BF6362@microsoft.com...
> 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" <TBoeck@discussions.microsoft.com> wrote in message
> > news:8E2E4FED-E159-498C-A694-BE2F330B6153@microsoft.com...
> > > 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.
> >
> >
> >

Bob,

I can't thank you enough. My boss will be VERY pleased.

Tim

"Bob Phillips" wrote:

> Essentially it is a macro that you can call directly from the worksheet, as
> it it were a function (UDF - User Defined Function). To create it, in Excel
> Alt-F11 will take you into the VBIDE. In the menu, select Insert>Module,
> then just copy that code into there. Then close the VBIDE.
>
> BTW, you can also get the login name which is a bit more reliable than the
> application name, as the user cannot change it. The VBA for that is
>
> Function UserName()
> UserName = Environ("UserName")
> End Function
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "TBoeck" <TBoeck@discussions.microsoft.com> wrote in message
> news:821E42CA-B0FF-4E55-8608-9557A0BF6362@microsoft.com...
> > 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" <TBoeck@discussions.microsoft.com> wrote in message
> > > news:8E2E4FED-E159-498C-A694-BE2F330B6153@microsoft.com...
> > > > 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.
> > >
> > >
> > >
>
>
>