Sub adapt_comment(cellule As Range)
maxlen = 0
x = Split(cellule.Comment.Text, Chr(10))
For n = LBound(x) To UBound(x)
If Len(x(n)) > maxlen Then maxlen = Len(x(n))
Next n
cellule.Comment.Shape.Width = maxlen * 5
cellule.Comment.Shape.Height = (UBound(x) + 1) * 12
End Sub