Excel VBA UserID help

[MichaelSFG]

Hello,

I am trying to create a worksheet for project approval. My current formula has it when a checkbox is clicked, it displays time and a message. I would like the message (now "complete") to display the user id associated with the individual that clicks on the box. Here is what I have so far

Private Sub CheckBox10_Click()
Dim LR As Long
LR = Range("L" & Rows.Count).End(xlUp).Row + 10
If LR < 3 Then LR = 3
If CheckBox10 Then Range("J" & LR) = Now & " - Complete"
End Sub

Is it is as simple as changing the "Complete" to some userid formula? I tried "Environ("Username") and kept getting error messages "Compile Error: Expected: end of statement"

Thanks,
Michael

 

[BiocideJ]

You basically said it. Not sure why you are getting an error but try this.

Private Sub CheckBox10_Click()
Dim LR As Long
LR = Range("L" & Rows.Count).End(xlUp).Row + 10
If LR < 3 Then LR = 3
If CheckBox10 Then Range("J" & LR) = Now & " " & Environ("Username")
End Sub

 

[Marcelo Branco]

Maybe

If CheckBox10 Then Range("J" & LR) = Now & " - " & Environ("Username")

M.

 

[MichaelSFG]

"= Now & " " & Environ("Username")"

That fixed it. Thanks! This was driving me nuts for about an hour.
Appreciate the help all!