Error Environ | Username

[joshcas]

HI,
I’m working to set the value of a variable to “Environ(“Username”)” but I’m getting an error about “Constant expression required” , not sure what I’m doing wrong

Const computeruser = Environ("USERNAME")

Any help will be much appreciated
josh

 

[AlphaFrog]

You are setting the value of a constant and not a variable.

This is from the Const help.
"You can't use variables, user-defined functions, or intrinsic Visual Basic functions (such as Chr) in expressions assigned to constants."

Environ is an intrinsic VBA function.

 

[joshcas]

thanks ,now is clear :D