View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default What is the function for system to capture the username

Function UserNameWindows() As String
UserName = Environ("USERNAME")
End Function

Thanks to Charles Maxson. See
http://blogs.officezealot.com/charle...2/10/3574.aspx

You can put it in any cell...

"Dave VB logic for excel" wrote:

Hello,

im currently working in excel sheet. i wanto add function where it can
capture the username whenever any users open the sheet. It can capture from
system or licencing. I would like to know the function or vb formula.

Please help

Thanks in advanced