Formula to show user name?

S

Snoopy

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
 
B

Bob Phillips

Create a UDF

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

=ThisUser()

--
HTH

Bob

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

Snoopy

Create a UDF

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

=ThisUser()

--
HTH

Bob

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







- Vis sitert tekst -

Thanks Bob :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top