Private Sub UserForm_Initialize()
Dim LABELS_USF As Control
Dim TOPS_LABELS_USF As Integer
TOPS_LABELS_USF = 20
For i = 4 To ActiveSheet.Range("A65536").End(xlUp).Row
Set LABELS_USF = UserForm1.Frame1.Controls.Add("Forms.Label.1", , True)
With LABELS_USF
.Left = 6
.Width = 100
.Height = 20
.Top = TOPS_LABELS_USF
.BackColor = &HFFFFFF
.ForeColor = &H800000
.Caption = ActiveSheet.Cells(i, 1).Value & " : "
.Font.Size = 14
.TextAlign = fmTextAlignRight
With .Font
.Italic = False
.Bold = True
.Name = "Times new roman"
.Size = 18
End With
End With
TOPS_LABELS_USF = TOPS_LABELS_USF + 26
Next i
End Sub