Function UserNameWindows()

[Darruk]

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

I tried using the above function and it compiles properly but there is no output in the cell I apply the function to. I can see the function in the insert function field below the tool bars, but the cell is blank.

I am trying to fill the cell with the current logged in user's name.

Anyone have any suggestions?

 

[lenze]

Hi and welcome to the board!!
You're close

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

I would, however, probably not use a UDF for this. What are you really trying to do?

lenze