Private Function NbreLignes(Etiquette As Label) As Integer Dim LargLign As Long, i As Integer FontBold = True Dim LargEtiq As Long: LargEtiq = Etiquette.Width Dim tablo() As String tablo = Split(Etiquette.Caption, " ") i = -1 Do i = i + 1 LargLign = LargLign + TextWidth(tablo(i)) If LargLign > LargEtiq Then NbreLignes = NbreLignes + 1 i = i - 1 LargLign = 0 End If If LargLign = LargEtiq Then NbreLignes = NbreLignes + 1 LargLign = 0 End If If i = UBound(tablo) And LargLign <> 0 Then NbreLignes = NbreLignes + 1 End If Debug.Print i, LargLign, NbreLignes Loop Until i = UBound(tablo) End Function
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questiondo Until i = UBound(tablo) loop
do Loop Until i = UBound(tablo)