Excel/Windows username in Excel

[najamabbas]

Good morning folks, I am trying to populate excel/windows username in a cell and using following formula:

Sub GetUser()
Range("Q299").Value = Environ("UserName")
End Sub


Sub GetUser()
Range("Q300").Value = Application.UserName
End Sub

But it's not working. Any suggestion?

 

[RoryA]

They are both correct - what exactly is happening?

 

[najamabbas]

=Getuser() this is the cell value and i am getting "#Name?" Error

 

[RoryA]

Those are subroutines not functions, so you can't call them from a cell. You need:

Function GetUser() as String
GetUser = Environ("UserName")
End Function

for example.