【VBA】Get User Name

You can get
“User Name“！

Use “Environ function“！

Contents

VBA Code

You can get “User Name” by “Environ function“.

Sub sampleProc()
    'Get "User Name"
    MsgBox Environ("USERNAME")
End Sub

Set “USERNAME” to “Environ function“(Line 3).

You got “User Name“！

Also, you can get “Computer Name“.

For more information, see the following article:

Also, you can get “path to the Desktop“.

For more information, see the following article:

For more information about following, see the following official online manual:

●Environ function