Add the Environ("UserName") to a cell with additional verbiage.

[gheyman]

How do I insert the Current user into the value I am trying to add to cell R3 (see below)?
Thanks for the Help!

Private Sub CommandButton1_Click()
CurrentUser = Environ("UserName")

Sheets("TitlePage").Select

'Sheets("Search").Range("R3").Value = "User XXXXYYY.SUUEEHSH verified that they read the opening statements"

UserForm2.Hide

End Sub

 

[Joe4]

Remember, variables must appear OUTSIDE of the double-quotes. Anything within double-quotes is treated as literal text.
And you sew/concatenate literal text and variables together with the "&" operator.

So you would need something like:

Sheets("Search").Range("R3").Value = "User " & CurrentUser & " verified that they read the opening statements"

 

[Georgiboy]

I would say:

Sheets("Search").Range("R3").Value = "User: " & CurrentUser & " verified that they read the opening statements"

 

[gheyman]

Thank you both. Appreciate the support and help.