1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Public Sub RemplirCommentaire(Vcells, Tintervention)
On Error GoTo Err_RemplirCommentaire
Dim k As Integer
Dim vAncienTexte As String
Vcells.AddComment
Vcells.Comment.Text Text:=" "
Selection.ShapeRange.ScaleWidth 5.01, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 3.07, msoFalse, msoScaleFromTopLeft
k = 0
While Not Tintervention.EOF
vAncienTexte = Vcells.Comment.Text
Vcells.Comment.Text Text:=vAncienTexte & Tintervention!libelleAction & Chr(10) & ""
k = k + 1
Tintervention.MoveNext
Wend
Vcells.Value = k
Exit_RemplirCommentaire:
Exit Sub
Err_RemplirCommentaire:
MsgBox Err.Description
Resume Exit_RemplirCommentaire
End Sub |
Partager