Bonjour,
Merci du retour. Voici les codes à placer dans l'USF picking
1. Validation : Remplacer le code existant par celui ci -dessous
Private Sub valider_picking_Click()
Dim vartab(0, 20) As Variant
Dim cvide As Integer
Dim ctrl As Control
Dim NBRDOSS As Boolean
Dim cle As String, valeurKO As String, chkNom As String
Dim datet As Date
datet = Format(Now, "dd/mm/yyyy")
Dim hpick As Date
hpick = Format(Now, "hh:nn:ss")
If Me.MultiPage1.Pages(0).Enabled = True Then
If Me.Ass_produit = "" Or Me.Ass_com = "" Or Me.ass_preco = "" Then
MsgBox "Merci de compléter la conclusion, le type de produit, la conclusion ainsi que les préconisations"
Exit Sub
End If
Application.ScreenUpdating = False
cvide = ThisWorkbook.Sheets("bdd_picking").Cells(Rows.Count, 1).End(xlUp).Row + 1
For Each ctrl In Picking.MultiPage1.Pages(0).Controls
If TypeOf ctrl Is MSForms.CheckBox Then
If ctrl = True Then
cle = cvide - 1
vartab(0, 0) = cle
vartab(0, 1) = Me.nom_manager.Text
vartab(0, 2) = Me.nom_collaborateur.Text
vartab(0, 3) = Me.num_sinistre.Value
vartab(0, 4) = "perimetre"
vartab(0, 5) = ctrl.Tag
vartab(0, 6) = ctrl.Caption
chkNom = ctrl.Name
Traitement chkNom, valeurKO
vartab(0, 7) = valeurKO
vartab(0, 8) = Me.Conclusions.Text
vartab(0, 9) = Me.Ass_com.Text ' a adapter
vartab(0, 10) = Me.ass_preco.Text ' a adapter
vartab(0, 11) = datet
vartab(0, 12) = Environ("Username")
vartab(0, 13) = "grand compte"
vartab(0, 14) = "1"
vartab(0, 15) = "type sinistre"
vartab(0, 16) = Me.num_sinistre & "-" & hpick
If vartab(0, 16) = Sheets("bdd_picking").Cells(cvide - 1, 17).Value Then
NBRDOSS = 0
Else: NBRDOSS = 1
End If
vartab(0, 17) = NBRDOSS
vartab(0, 18) = Me.Ass_produit.Text
ThisWorkbook.Sheets("bdd_picking").Cells(cvide, 1).Resize(1, 19) = vartab
cvide = cvide + 1
End If
End If
Next ctrl
End If
Unload Me
Application.ScreenUpdating = True
End Sub
2. Ajouter le code Traitement (en dessous du code valider ou ailleurs mais dans l'USF)
Private Sub Traitement(chkNom As String, valeurKO As String)
Select Case Mid(chkNom, 9)
Case Is = 4: valeurKO = RechUKO.Value
Case Is = 5: valeurKO = ContdevisKO
Case Is = 6: valeurKO = ReceptKO
Case Is = 7: valeurKO = TraitKO
Case Is = 8: valeurKO = CTKO
Case Is = 9: valeurKO = PVKO
Case Is = 10: valeurKO = InfoKo
Case Is = 11: valeurKO = PECKO
End Select
End Sub
Si ok-->
Cordialement