Formula to show user name?

  • Thread starter Thread starter Snoopy
  • Start date Start date
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
 
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)
 
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 -
Click to expand...

Thanks Bob :)
 
Back
Top