Record time based on value being selected in list box

Hello,

I'm trying to figure out how to record the time that a user selects an option in a list box. I have two list boxes in their own sheet that get their info from two different worksheets.

I pass the listvalue to the worksheet, to select the item. But I need to record the time the listvalue changed on that worksheet. I put code below into a sheet, but it only works when I manually change the number in E4, not when you change the value of E4 (the listvalue) by using the drop down.

Please, please any help really gratefully appreciated!

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("E4"), .Cells) Is Nothing Then
Application.EnableEvents = True
If IsEmpty(.Value) Then
.Offset(0, 3).ClearContents
Else
With .Offset(0, 2)
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub