how do I insert user name into a cell

[Grant Robertson]

I am trying to insert the user name from the Tools Options General tab into a
spreadsheet cell.
I have EXCEL 2003

 

[Ron Coderre]

You'd need a User Defined Function (UDF) to do that if you're interested in
implementing a short VBA program:

This website gives instructions for getting the Excel Username and the
Logged In Username:
http://www.dicks-blog.com/archives/2004/06/17/get-the-username-in-vba/

Does that help?

***********
Regards,
Ron

 

[Ron Coderre]

But, the easiest way would be:

Open a standard VBA module and past in this code:

'----Start of Code------
Option Explicit
Function NetworkUserName() As String
Dim response
NetworkUserName = Environ("Username")
End Function
'----End of Code------

Then...in any ceil in that workbook enter: =NetworkUserName()

Does that help?

***********
Regards,
Ron

 

[Grant Robertson]

Ron,
This gives me my network log in name.
I need my EXCEL user name.
I have tried ammending your code and the code from the link you supplied but
cannot make it work.

Cheers
Grant

 

[Grant Robertson]

Ron,
I have it problem solved thanks

Ron,
This gives me my network log in name.
I need my EXCEL user name.
I have tried ammending your code and the code from the link you supplied but
cannot make it work.

Cheers
Grant