windows username

[max_max]

Hello to all,
you can enter in a cell who is using the computer or excel? Is there a formula or do I need a macro?
max_max
--------------------------------------------------------------------------------------------------------------
Ciao a tutti,
è possibile inserire in una cella chi sta usando il computer o excel? C'è una formula oppure ho bisogno di una macro?
max_max

[LJMetzger]

I couldn't find any built in function for this.

Try the following Macro:

Sub TestEnvironmentVariable()
  Dim sEnvVariableName As String
  
  sEnvVariableName = "USERNAME"
  Range("A1") = GetEnvironmentVariableValue(sEnvVariableName)
End Sub

Function GetEnvironmentVariableValue(sEnvVariableName As String)
  GetEnvironmentVariableValue = Environ(sEnvVariableName)
End Function