The User Name is set under Tools, Options, General tab. However, if you're trying to get the name of the person logged into Windows, you'll need the following code:

 

Environ("USERNAME")

You could create a function as follows:

 

Function UserNameWindows() As String
    UserName = Environ("USERNAME")
End Function

If you want to get the name of the user, use

 

application.UserName

 

If you're trying to get someone else, let me know

Allan I tried that and it returned " " . I am looking for a way to access the screen account name.

Thanks for your reply

CrosbyLake

Allan that works great exactly what I'm looking for "Thanks Millions".

Q. Where can I learn how use some of these capabilities of VB Excel?

CrosbyLake

There are a number of books that deal with Excel VBA. John Walkenbach has a very good book, as do other authors. Check out www.bookpool.com for ideas.