chaelie2015
XLDnaute Accro
Bonjour Forum
je souhaite simplifier ce code si c'est possible
merci par avance
je souhaite simplifier ce code si c'est possible
Code:
Sub MES_PREVUE()
If TextBox10 <> "" And TextBox11 <> "" And [COLOR="#FF0000"]ComboBox8.Value = "Mois"[/COLOR] Then _
TextBox14.Value = DateAdd("m", TextBox11, TextBox10) Else TextBox14 = ""
If TextBox10 <> "" And TextBox11 <> "" And [COLOR="#FFFF00"]ComboBox8.Value = "Jour(s)"[/COLOR] Then _
TextBox14.Value = DateAdd("d", TextBox11, TextBox10) Else TextBox14 = ""
If TextBox10 <> "" And TextBox11 <> "" And [COLOR="#00FF00"]ComboBox8.Value = ""[/COLOR] Then _
TextBox14.Value = ""
End Sub