With .Range(Cells(LgTrav, ColDebut), Cells(LgTrav, ColFin))
.Interior.ColorIndex = 1
.Interior.Pattern = xlSolid
.Font.ColorIndex = 2
.FormulaR1C1 = TextBox2.Value & " Status: CANCELLED / ABORTED"
LgTx3 = TextBox2.TextLength
'.Range(Cells(LgTrav, ColDebut), (Cells(LgTrav, ColFin))).AddComment
'.Range(Cells(LgTrav, ColDebut), Cells(LgTrav, ColFin)).Comment.Visible = False
'.Range(Cells(LgTrav, ColDebut), Cells(LgTrav, ColFin)).Comment.Text Text:="bla...bla" & Chr(10) & ""
End With