expression.UserName
expression Required. An expression that returns an Application object.
Example
This example sets the user's name.
Application.UserName = "Andrew Fuller"
This example returns the name found in the Name box on the User Information tab in the Options dialog box (Tools menu).
Msgbox Application.UserName