1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| Private Sub TextBox_MDCode_AfterUpdate()
'Value entered necessarilly has 6 digits'
Dim c As Variant
If Len(TextBox_MDCode.Value) <> 6 And Len(TextBox_MDCode.Value) <> 0 Then
Select Case MsgBox("Le code doit comporter 6 caractères", vbOKOnly)
Case vbOK
TextBox_MDCode.Value = ""
TextBox_MDCode.SetFocus
End Select
Else: Range("MDCode_Field")(TextBox_Prev_Next.Text).Value = TextBox_MDCode.Value
End If
'Verify whether the code entered already exists and where'
Set c = Range("MDCode_Field").Find(TextBox_MDCode, LookIn:=xlValues, LookAt:=xlWhole)
If Not c Is Nothing Then
Select Case MsgBox("Vérifiez le code et assurez vous que ce Centre ne soit pas déjà enregistré", vbOKOnly, "Code Existant")
Case vbOK
TextBox_MDCode.Value = ""
Range("MDCode_Field")(TextBox_Prev_Next.Text).Value = ""
TextBox_MDCode.SetFocus
End Select
Else: Range("MDCode_Field")(TextBox_Prev_Next.Text).Value = TextBox_MDCode.Value
End If
End Sub |
Partager