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
| UserForm7.ListBox11.Clear
ReDim Preserve Tb1(UBound(ary, 1), UBound(ary, 2))
For i = 1 To UBound(ary, 1)
k = 0
For j = 1 To UBound(ary, 2)
k = k + ary(i, j)
Next j
If k > pmin And k < pmax Then
Tb1(i, 1) = ary(i, 1)
Tb1(i, 2) = ary(i, 2)
Tb1(i, 3) = ary(i, 3)
Tb1(i, 4) = ary(i, 4)
Tb1(i, 5) = ary(i, 5)
If Tb1(i, 1) <> 0 And Tb1(i, 2) <> 0 And Tb1(i, 3) <> 0 And Tb1(i, 4) <> 0 And Tb1(i, 5) <> 0 Then
UserForm7.ListBox11.AddItem (Tb1(i, 1) & vbTab & Tb1(i, 2) & vbTab & Tb1(i, 3) & vbTab & Tb1(i, 4) & vbTab & Tb1(i, 5))
End If
End If
Next i
p = UserForm7.ListBox11.ListCount
UserForm7.Label1125.Caption = p & " Nbre des possibles " |
Partager