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
| Private Sub ComboRotation_Change()
Dim ColonneTAtester As Byte
Dim LigneATester As Integer
Dim Variable As String
Dim NbLigneUtilisée As Integer
Dim Types As String
ListLégumes.Clear
Select Case ComboMoisSemis.ListIndex
Case 0
Variable = "SI"
Case 1
Variable = "SER"
Case 2
Variable = "FR"
Case Else
Exit Sub
End Select
Types = ComboRotation.Text
With Sheets("BaseJM")
ColonneTAtester = Me.ComboMois.ListIndex + 4
For LigneATester = 3 To .Range("C65536").End(xlUp).Row
If .Cells(LigneATester, ColonneTAtester) = Variable And .Cells(LigneATester, 2) = Me.ComboFamilleQuePlanter And .Cells(LigneATester, 22) = Types Then
Me.ListLégumes.AddItem
Me.ListLégumes.List(NbLigneUtilisée, 0) = .Range("C" & LigneATester)
NbLigneUtilisée = NbLigneUtilisée + 1
End If
Next
End With
End Sub |