Dim choix
Private Sub UserForm_Initialize()
choix = Sheets("lexique").Range("A2:B" & Sheets("lexique").Range("A2").End(xlDown).Row).Value
With Lexique1
.StartUpPosition = 0
.Top = 20
.Left = 300
.Height = 266
End With
TextBox1.Text = "Entrez le mot à définir": TextBox1.ForeColor = RGB(200, 200, 200)
TextBox2.Text = "Entrez la définition": TextBox2.ForeColor = RGB(200, 200, 200)
Me.ComboBox1.ColumnCount = 2
Me.ComboBox1.ColumnWidths = "30;0"
Me.ComboBox1.List = choix
End Sub
Private Sub ComboBox1_Change()
With Label1
.Caption = Me.ComboBox1.Column(1)
.TextAlign = fmTextAlignCenter
.WordWrap = True
End With
End Sub