Show Username in Cell
Show Username in Cell
(OP)
Is there a way to have a cell in excel show the username as entered in a network login?
Thanks,
Tripp
Thanks,
Tripp
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Show Username in Cell
- Go to the VB Editor (Alt-F11)
- Insert > Module
- Add the following code
Function UserName() As String
UserName = UCase(Environ("username"))
End Function
- Close the VB Editor
- Select the target cell
- Insert > Function > User Defined > UserName
Hit OK and you should be good.
It should work on most versions of Windows (NT, 2K, XP)
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Show Username in Cell
Thanks,
Tripp
RE: Show Username in Cell
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Show Username in Cell
RE: Show Username in Cell
I have created a spreadsheet and saved it on a server, When someone edits this file i want it to put their username in a cell and save it so we can see who last updated it automatically.
Any ideas?
thanks
emeralds
RE: Show Username in Cell
If you want it to automatically run when the file is opened, use the Workbook_Open() sub in the ThisWorkbook object to call your macro. If you only want to update upon save, use the Workbook_Save() event to trigger your macro.
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Show Username in Cell
RE: Show Username in Cell
JimB