Private Sub TextBox1_AfterUpdate()
TextBox1 = Format(TextBox1, "dd/mm/yyyy")
TextBox2 = IIf(CDate(TextBox1) <= Date, "Date Limite " & CDate(TextBox1) + 7 & " il vous reste " & _
IIf(Date - CDate(TextBox1) < 2, Date - CDate(TextBox1) & " jour", Date - CDate(TextBox1) & " jours"), "Date limité expirée")
End Sub