Dim rg As Range
Dim rg2 As Range
Set rg = Sheets("Dpt BDD").Range("B:B").Find(TextBox24.Text, LookIn:=xlValues, LookAt:=xlWhole)
Set rg2 = Sheets("Dpt BDD").Range("A:A").Find(TextBox23.Text, LookIn:=xlValues, LookAt:=xlWhole)
If Not rg And rg2 Is Nothing Then
MsgBox "Client déjà enregistré ce jour"
Cancel = True
With Me
.TextBox24.Value = ""
.TextBox25.Value = 0
End With
Exit Sub
End If