Hi,

Am Wed, 15 Apr 2015 11:54:56 -0700 (PDT) schrieb :

Ok, thanks! I understand now and am getting it to work. However, I thought this would be more of a formula than a format. Let's say I have multiple tabs that this would apply to where the X's would be all done in column L and I would need the time stamp to show in Column M in the row. How would that get applied to the entire worksheet? Thanks for your help.

Alt+F11 = Double click on "ThisWorkbook" and insert following code
into the code window:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
If Target.Address < "$L$115" Then Exit Sub

With Target.Offset(, 1)
If LCase(Target) = "x" Then .Value = Date
.NumberFormat = "MM/DD/YY"
End With
End Sub


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional