VBA/Formula for Username

[Mykiej23]

Hi,

I am trying to get a formula that will generate whoever is inputting the reports username in a cell. After some research online, I've come across a VBA UDF but I'm not sure if I am doing it right.

I've tried creating a new module and adding the following:

Function Username()
    Username = Environ$("USERNAME")
End Function

And then in the cell
=Username()

However, it will only generate my username, no matter who is doing the report. Have I missed something or is there something I can do to get this working?

Thank you for any help offered

Thanks,
Michaela

 

[jasonb75]

As the function is not volatile and has no precedent cells it will never be recalculated. If it was recalculated then it would show the name of the person viewing the report, which might not necessarily be the creator.

Assuming that the report is run in vba, I would suggest adding the username directly to the cell as part of that process as opposed to using a function / formula.