Formula to show user name?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Snoopy - 08 Feb 2008 09:23 GMT

Hey guys
I'm working with a Excel-form to be used by several users.
It would be convenient to show/place the current user's name in a
cell.
Is there any formula that transports this user name from MS properties
funktion into my Excel-cell?

Regards
Snoopy

Reply to this Message

Bob Phillips - 08 Feb 2008 11:27 GMT

Create a UDF

Function ThisUser()
ThisUser = Environ("Username")
End Function

=ThisUser()

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hey guys
> I'm working with a Excel-form to be used by several users.
[quoted text clipped - 5 lines]
> Regards
> Snoopy

Reply to this Message

Snoopy - 08 Feb 2008 12:42 GMT

> Create a UDF
>
[quoted text clipped - 22 lines]
>
> - Vis sitert tekst -

Thanks Bob :)

Reply to this Message