Adding username if X is in a certain cell

[dh231]

I am trying to have a checklist that when a user checks off an item it logs their name in the cell below.
My code is as follows but it does nothing.:

If Target.Column = 2 Then
    If Target = "X" Or Target = "x" Then
        Application.EnableEvents = False
            Target.Offset(1, 0) = Environ("Username")
        Application.EnableEvents = True
    End If
End If

End Sub

This is a sample of my worksheet. Any assistance will be much appreciated.

TASK	Day1	Day2
Task 1	X
Initial	name
Task 2		X
Initial		name

 

[VBE313]

How about

Target.Offset(1, 0).value

Instead of

Target.Offset(1, 0)

 

[Fluff]

Hi & welcome to MrExcel.
That code is working on column B only, what columns should it work on?
Also what is the name of the procedure, as you haven't supplied that?

 

[dh231]

Sorry, missed a line:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 2 Then
    If Target = "X" Or Target = "x" Then
        Application.EnableEvents = False
            Target.Offset(1, 0).Value = Environ("Username")
        Application.EnableEvents = True
    End If
End If

End Sub

I would like it to work on all columns B:AF

Tried the

Target.Offset(1, 0).Value

Nothing changed.

 

[Fluff]

Ok, how about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Not Intersect(Target, Range("B:AF")) Is Nothing Then
      If LCase(Target) = "x" Then
         Application.EnableEvents = False
         Target.Offset(1).Value = Environ("Username")
         Application.EnableEvents = True
      End If
   End If
End Sub

 

[dh231]

That's not producing any results either.

 

[Fluff]

Where is the code located? Is it in the correct sheet module?

 

[dh231]

I think so. I have only 1 workbook open, 1 sheet. It's listed under Modules as Module1

 

[Fluff]

It needs to go in the Sheet module, not a regular module.
In the VB Editor double click the sheet in the project window & paste the code into the code window that opens up.

 

[dh231]

OMG - lol thank you very much. This looks to be working wonderfully!!