Private Sub UserForm_Activate()
For i = 1 To Sheets("liste").Cells(Rows.Count, "A").End(xlUp).Row
With Me.Controls.Add("Forms.Label.1", "Bt" & i, True)
Set cel = Sheets("liste").Cells(i, "A")
.Caption = cel
.Top = 18 * (i - 1)
.Left = 0
.Width = cel.Width
.Height = 18
.BackColor = cel.Interior.Color
.Font.Name = cel.Font.Name
.ForeColor = cel.Font.Color
.Font.Bold = cel.Font.Bold
.Font.Size = cel.Font.Size
.TextAlign = IIf(cel.HorizontalAlignment = xlCenter, 2, 1)
.BorderStyle = 1: .BorderColor = &HFFFFC0
End With
With Me.Controls.Add("Forms.Label.1", "Bt2" & i, True)
.Caption = cel.Offset(, 1)
.Top = 18 * (i - 1)
.Left = cel.Width + 1
.Width = cel.Offset(, 1).Width
.Height = 18
.BackColor = cel.Offset(, 1).Interior.Color
.Font.Name = cel.Offset(, 1).Font.Name
.ForeColor = cel.Offset(, 1).Font.Color
.Font.Bold = cel.Offset(, 1).Font.Bold
.Font.Size = cel.Offset(, 1).Font.Size
.TextAlign = IIf(cel.Offset(, 1).HorizontalAlignment = xlCenter, 2, 1)
.BorderStyle = 1: .BorderColor = &HFFFFC0
End With
Next
Me.Height = (i * 18)
Me.Width = Sheets("liste").Range("A1:B1").Width
End Sub