Timestamp based on List Box Macro

I'm trying to create a timstamp based on the values that a List Box produces. I tried to apply a timestamp I previously used but it doesn't work on the List Box Value. Here's an example of the timestamp I'm trying to use.

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

Any idea how I can modify so the timestamp will work based on the value the List Box produces?

Any suggestions? I'm stumped.

Hi BVT,

I didn't use a lisbox, but put values in a new workbook (all formats general) in cell "C2" and got the expected result (using Excel 2003) in Cell "D2" (.e.g. "4/15/2014 5:52:02 PM").

When I changed the format of "D2" to text or a number, I still get the desired result.

I'm stumped too.

Lewis