Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
For Each c In Range("D7:D32")
If c.Value Like "*ILINO*" Then GoTo suite
If c.Value <> "" Then c.Value = c.Value & " ILINO " & Year(Date)
suite:
Next
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
For Each c In Range("D8:D32")
If c.Value Like "*ILINO*" Then GoTo suite
If c.Value <> "" Then c.Value = c.Value & "/ILINO/" & Year(Date)
suite:
Next
End Sub
Option Explicit
Private Sub Worksheet_Selectionchange(ByVal Target As Range)
If Not Intersect(Target, Range("D7:D32")) Is Nothing Then
If Target = "" Or Len(Target) > 14 Then Exit Sub
Cells(Target.Row, 4) = Target.Value & Format(Date, " / ILINO / yyyy")
End If
End Sub