Excel function to return user name

[General Ledger]

Dear All,

I am looking for an Excel 2003 function to return the user's name to a cell.

If not a function, option two would be VBA to return the user's name to a cell.

Thanks,

GL

 

[dscg]

I believe VBA is the only way to go here. Try:

Function GetUser()
GetUser = Environ("UserName")
End Function

Returns currently logged in window's username.

 

[General Ledger]

The function works great. My only issue is it seems to pull the user name from the operating system. I was hoping to pull the user name from within Excel.

In Excel 2003, this is setup under Tools > Options > General This would be the same user name used by Excel when you insert a comment.

I tried but get an error with:
Sub GetUser()
Range("B3").Value = Application("UserName")
End Sub

 

[Oaktree]

Change Application("UserName") to Application.UserName

 

[General Ledger]

PERFECT!!!

To return user name from Excel:

Sub GetUser()
Range("B3").Value = Application.UserName
End Sub


To return user name from operating system:

Sub GetUser()
Range("B3").Value = Environ("UserName")
End Sub

Thanks dscg and Oaktree!

 

[Pauljj]

Try

Sub getuser()

Range("b3") = Application.UserName

End Sub

 

[wigi]

Pauljj

Or:

Sub getuser()
[b3] = Application.UserName
End Sub

if you want to type even less.

Wigi

 

[Pauljj]

Well I didn't know that Wigi, thanks, always good to know where you can save key strokes

Thanks for that