Private Sub Label_Modifier_Click()
Application.ScreenUpdating = False
Dim Maligne As Integer, I As Byte
Maligne = Me.ListBox_Base.ListIndex + 2
With Sheets("Feuil1")
For I = 1 To 10
.Cells(Maligne, 1).Value = Me("TextBox" & I)
Me.ListBox_Base.List(Me.ListBox_Base.ListIndex, I - 1) = Me("TextBox" & I)
Next
End With
'Unload Me
End Sub
Private Sub TextBox10_Change() 'entrer date sans séparateur ex:01012019,11022019
Select Case Len(Me.TextBox10)
Case 2, 5
TextBox10 = TextBox10 & "-"
End Select
End Sub
Private Sub TextBox9_Change()
Select Case Len(Me.TextBox9)
Case 2, 5
TextBox9 = TextBox9 & "-"
End Select
End Sub