VBA Time Stamp but only if equalling specific data validation

[Greenies08]

Hi, I am not knowledgable in VBA at all. I have found the following that works a treat to time stamp in column J when column K is not equal to nothing. BUT, I want a separate timestamp that will time stamp only when the selection in Column K is specific i.e. "3. Send to Accounts"

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns("H:H")) Is Nothing Then
For Each I In Intersect(Target, Columns("H:H"))
If Not IsEmpty(I) Then
I.Offset(0, 2).Value = Now
Else
I.Offset(0, 2).ClearContents
End If
Next I
End If
End Sub

Appreciate anyone's brain power and will give all credibility to you

 

[Greenies08]

Yes and I've retyped everything to make double sure and also tried removing data validation just in case

 

[Greenies08]

TEST (1)


I have created a simple version (columns now A-D). I have change the VBA accordingly I think.

Any help truly appreciated.

 

[Fluff]

Thanks for the test file.
In it you have 3. Sent To Lender, rather than 3. Send to Accounts, which is one reason why it's not working.
The other is that I misread the code.
try

Private Sub Worksheet_Change(ByVal Target As Range)
   If Not Intersect(Target, Columns("a:a")) Is Nothing Then
      For Each i In Intersect(Target, Columns("a:a"))
         If i.Value = "3. Sent To Lender" Then
            i.Offset(, 3).Value = Now
         ElseIf Not IsEmpty(i) Then
            i.Offset(0, 2).Value = Now
         Else
            i.Offset(0, 2).ClearContents
         End If
      Next i
   End If
End Sub

 

[Greenies08]

You are a legend, that is perfect. Thank you so so much and for persevering with me

 

[Fluff]

Glad to help & thanks for the feedback