Private Sub Cbn_NouveauDevis_Click()
Dim X&, Z&
TbL = Range("archivedevis").Value
For I = 1 To UBound(TbL)
X = Val(Replace(TbL(I, 1), "D", ""))
If Z <= X Then Z = X
Next
Cbx_Devis.Value = Format(Z + 1, """D""0000")
Cbx_Client = ""
Tbx_Raison = ""
Tbx_DateDevis = ""
ListBX.Clear
End Sub