aperobass
XLDnaute Junior
salut à tous, j'ai un petit problème.Je veux refaire un code qui à la même fonction.
Ce code sert à chercher les doublons.
valeurAdditionee = Val(Right(TextBox3, 5)) + (ComboBox3 - 1)
TextBox4 = Left(TextBox3, 1) & Application.Rept("0", 5 - Len(valeurAdditionee)) & valeurAdditionee
RefDebut = TextBox3.Value
nbRef = ComboBox3.Value
Set zoneDesRef = Range("B4:B2000,D4: D2000")
For Each cellule In zoneDesRef
For i = 0 To nbRef
numNouvelleRef = Val(Right(RefDebut, 5)) + i
longNum = Len(numNouvelleRef)
refATrouver = Left(RefDebut, 1) & Application.Rept("0", 5 - Len(valeurAdditionee)) & numNouvelleRef
If cellule.Value = refATrouver Then
trouver = "OUI"
Exit For
End If
Next
If trouver = "OUI" Then
Exit For
End If
Next
If trouver = "OUI" Then
MsgBox ("Une référence existante a été trouvée")
Unload sérial
A la place de ce code:
valeurAdditionee = Val(Right(TextBox3, 5)) + (ComboBox3 - 1)
TextBox4 = Left(TextBox3, 1) & Application.Rept("0", 5 - Len(valeurAdditionee)) & valeurAdditionee
Je met ça:
valeurAdditionee = Mid(TextBox3, 1, InStr(TextBox3, "D") - 1)
reste = Mid(TextBox3, InStr(TextBox3, "D"))
valeurAdditionee = valeurAdditionee + Val(ComboBox3)
TextBox4 = Left(mot, Len(mot) - Len(valeurAdditionee)) & valeurAdditionee & reste
Je n'arrive pas à faire la suite ça bloque?
A+
Ce code sert à chercher les doublons.
valeurAdditionee = Val(Right(TextBox3, 5)) + (ComboBox3 - 1)
TextBox4 = Left(TextBox3, 1) & Application.Rept("0", 5 - Len(valeurAdditionee)) & valeurAdditionee
RefDebut = TextBox3.Value
nbRef = ComboBox3.Value
Set zoneDesRef = Range("B4:B2000,D4: D2000")
For Each cellule In zoneDesRef
For i = 0 To nbRef
numNouvelleRef = Val(Right(RefDebut, 5)) + i
longNum = Len(numNouvelleRef)
refATrouver = Left(RefDebut, 1) & Application.Rept("0", 5 - Len(valeurAdditionee)) & numNouvelleRef
If cellule.Value = refATrouver Then
trouver = "OUI"
Exit For
End If
Next
If trouver = "OUI" Then
Exit For
End If
Next
If trouver = "OUI" Then
MsgBox ("Une référence existante a été trouvée")
Unload sérial
A la place de ce code:
valeurAdditionee = Val(Right(TextBox3, 5)) + (ComboBox3 - 1)
TextBox4 = Left(TextBox3, 1) & Application.Rept("0", 5 - Len(valeurAdditionee)) & valeurAdditionee
Je met ça:
valeurAdditionee = Mid(TextBox3, 1, InStr(TextBox3, "D") - 1)
reste = Mid(TextBox3, InStr(TextBox3, "D"))
valeurAdditionee = valeurAdditionee + Val(ComboBox3)
TextBox4 = Left(mot, Len(mot) - Len(valeurAdditionee)) & valeurAdditionee & reste
Je n'arrive pas à faire la suite ça bloque?
A+