Adding conditions to a time stamp in VBA

[Mikeymike_W]

Hi Everyone,

I have the following code to populate a timestamp in column 38 when the value of a cell in column 13 is changed:

If Target.Column = 13 Then
Application.EnableEvents = False
Cells(Target.Row, 38).Value = Date + Time
Application.EnableEvents = True
End If

I was wondering if it is possible to create a condition where this is ignored?
So if the cell in column 13 is populated with the text "TBC" then the time stamp wont be generated?

Many thanks for your help,

Mike

 

[mole999]

its going to be something like


If Target.Column = 13 AND Cells(Target.Row, 38).Value <> "TBC" Then

would need testing and refining as appropriate as I can't see it exactly

 

[Mikeymike_W]

Hi Mole,

Thanks for such a quick response.

Worked like a charm.

I just changed the cell reference to 13 as that is the cell with "TBC" in it.

Thanks a million buddy!