1 réponse
Bonjour,
textbox vide ou pas une date
textbox vide ou pas une date
Private Sub CommandButton1_Click() If Me.TextBox1.Value = "" Or Not IsDate(TextBox1.Value) Then MsgBox ("Please Enter a value Date") TextBox1.SetFocus Exit Sub ElseIf Me.TextBox2.Value = "" Or Not IsDate(TextBox2.Value) Then MsgBox ("Please Enter a value Date") TextBox2.SetFocus Exit Sub End If Me.TextBox3 = Evaluate("datedif(" & "datevalue(""" & cvDate(Me.TextBox1) & """)" & ",datevalue(""" & cvDate(Me.TextBox2) & """),""y"")") Me.TextBox4 = Evaluate("datedif(" & "datevalue(""" & cvDate(Me.TextBox1) & """)" & ",datevalue(""" & cvDate(Me.TextBox2) & """),""ym"")") Me.TextBox5 = Evaluate("datedif(" & "datevalue(""" & cvDate(Me.TextBox1) & """)" & ",datevalue(""" & cvDate(Me.TextBox2) & """),""md"")") End Sub
oui ca marche merci pour ton aide