bien sur steelson, je vais préparer le fichier mais le problème réside tout simplement ici:
ce que je souhaites
si clic sur AZ10 alors
If (ActiveCell.Address = "$AZ$10") Then
'If TblBD(i, 4) = Date Then
Si clic sur AZ11 alors
ElseIf (ActiveCell.Address = "$AZ$11") Then
'If (TblBD(i, 4) >= Date - Weekday(Date, vbMonday) + 1) And (TblBD(i, 4) <= Date - Weekday(Date, vbMonday) + 7) Then
End If
le code d'affichage en listbox restant similaire après
mais je test comme cela ca me met next sans for à la ligne next i
Public Sub List_ToBeDone()
ColVisu = Array(1, 2, 3, 5, 6)
LargeurCol = Array(1, 35, 80, 39, 45)
nomtableau = "T_Tasks"
TblBD = Range(nomtableau)
List_Tasks_tobedone.ColumnCount = Range(nomtableau).Columns.Count
List_Tasks_tobedone.ColumnWidths = Join(LargeurCol, ";")
Dim Tbl()
For i = 1 To UBound(TblBD)
If (ActiveCell.Address = "$AZ$10") Then
If TblBD(i, 4) = Date Then
ElseIf (ActiveCell.Address = "$AZ$11") Then
If (TblBD(i, 4) >= Date - Weekday(Date, vbMonday) + 1) And (TblBD(i, 4) <= Date - Weekday(Date, vbMonday) + 7) Then
End If
n = n + 1: ReDim Preserve Tbl(1 To UBound(TblBD, 2), 1 To n)
c = 0
For Each K In ColVisu
c = c + 1: Tbl(c, n) = TblBD(i, K)
Next K
End If
Next i
If n > 0 Then List_Tasks_tobedone.Column = Tbl Else List_Tasks_tobedone.Clear
End Sub