Sub GetTheNameEnviron()

[Joxu]

Hi !

Sub GetTheNameEnviron()
MsgBox " Environ username is:" " & Environ("USERNAME")

How i can get that information to the sheet1 in cell a1 ?

Regards

-Joxu

 

[Andrew Poulsom]

Like this?

Worksheets("Sheet1").Range("A1").Value = Environ("USERNAME")

 

[Jonmo1]

Sheets("Sheet1").Range("A1").Value = Environ("USERNAME")

Or if you actually want the whole string "Environ username is: ...."

Sheets("Sheet1").Range("A1").Value = " Environ username is:" " & Environ("USERNAME")