Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula returning current user name
I'd like to find a way to have a cell automatically display the current user
name as shown in Tools/Options/General/User name. Thanks for the help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula returning current user name
You need a VBA UDF
Function UserName() Username=application.UserName End Function and then in the worksheet, use =UserName() -- HTH RP (remove nothere from the email address if mailing direct) "TBoeck" wrote in message ... I'd like to find a way to have a cell automatically display the current user name as shown in Tools/Options/General/User name. Thanks for the help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula returning current user name
Bob,
Thank you for the help. Just one last question (can ya tell I'm new?), what is a "VBA UDF" "Bob Phillips" wrote: You need a VBA UDF Function UserName() Username=application.UserName End Function and then in the worksheet, use =UserName() -- HTH RP (remove nothere from the email address if mailing direct) "TBoeck" wrote in message ... I'd like to find a way to have a cell automatically display the current user name as shown in Tools/Options/General/User name. Thanks for the help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula returning current user name
Essentially it is a macro that you can call directly from the worksheet, as
it it were a function (UDF - User Defined Function). To create it, in Excel Alt-F11 will take you into the VBIDE. In the menu, select InsertModule, then just copy that code into there. Then close the VBIDE. BTW, you can also get the login name which is a bit more reliable than the application name, as the user cannot change it. The VBA for that is Function UserName() UserName = Environ("UserName") End Function -- HTH RP (remove nothere from the email address if mailing direct) "TBoeck" wrote in message ... Bob, Thank you for the help. Just one last question (can ya tell I'm new?), what is a "VBA UDF" "Bob Phillips" wrote: You need a VBA UDF Function UserName() Username=application.UserName End Function and then in the worksheet, use =UserName() -- HTH RP (remove nothere from the email address if mailing direct) "TBoeck" wrote in message ... I'd like to find a way to have a cell automatically display the current user name as shown in Tools/Options/General/User name. Thanks for the help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula returning current user name
Bob,
I can't thank you enough. My boss will be VERY pleased. Tim "Bob Phillips" wrote: Essentially it is a macro that you can call directly from the worksheet, as it it were a function (UDF - User Defined Function). To create it, in Excel Alt-F11 will take you into the VBIDE. In the menu, select InsertModule, then just copy that code into there. Then close the VBIDE. BTW, you can also get the login name which is a bit more reliable than the application name, as the user cannot change it. The VBA for that is Function UserName() UserName = Environ("UserName") End Function -- HTH RP (remove nothere from the email address if mailing direct) "TBoeck" wrote in message ... Bob, Thank you for the help. Just one last question (can ya tell I'm new?), what is a "VBA UDF" "Bob Phillips" wrote: You need a VBA UDF Function UserName() Username=application.UserName End Function and then in the worksheet, use =UserName() -- HTH RP (remove nothere from the email address if mailing direct) "TBoeck" wrote in message ... I'd like to find a way to have a cell automatically display the current user name as shown in Tools/Options/General/User name. Thanks for the help. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula returning current user name
All,
This thread was very helpful. One issue that I am encountering is when I send the sheet to other users, the UDF doesn't update (the UDF below that gets the login name). Is there a way to force this UDF to exectue upon opening the sheet? Thanks, Dennis "TBoeck" wrote: Bob, I can't thank you enough. My boss will be VERY pleased. Tim "Bob Phillips" wrote: Essentially it is a macro that you can call directly from the worksheet, as it it were a function (UDF - User Defined Function). To create it, in Excel Alt-F11 will take you into the VBIDE. In the menu, select InsertModule, then just copy that code into there. Then close the VBIDE. BTW, you can also get the login name which is a bit more reliable than the application name, as the user cannot change it. The VBA for that is Function UserName() UserName = Environ("UserName") End Function -- HTH RP (remove nothere from the email address if mailing direct) "TBoeck" wrote in message ... Bob, Thank you for the help. Just one last question (can ya tell I'm new?), what is a "VBA UDF" "Bob Phillips" wrote: You need a VBA UDF Function UserName() Username=application.UserName End Function and then in the worksheet, use =UserName() -- HTH RP (remove nothere from the email address if mailing direct) "TBoeck" wrote in message ... I'd like to find a way to have a cell automatically display the current user name as shown in Tools/Options/General/User name. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Array formula returning terminated employees | Excel Worksheet Functions | |||
New user needing help with coming up with a formula | New Users to Excel | |||
Formula for Excel User Name | Excel Worksheet Functions |