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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
|
With Me.lbTasks
Me.lbTasks.ColumnWidths = "1;1.5"
Me.lbTasks.ColumnCount = 11
Me.lbTasks.AddItem ("headers")
.Column(0, Me.lbTasks.ListCount - 1) = ""
lbTasks.List(0, 1) = "test"
.Column(0, 2) = "Status"
.Column(0, 3) = "Category"
.Column(0, 4) = "Budget"
.Column(0, 5) = "Startdate"
.Column(0, 6) = "Deadline"
.Column(0, 7) = "Ticket"
.Column(0, 8) = "N°SD7"
.Column(0, 9) = "N°RIE"
.Column(0, 10) = "Stream owner"
For Each cActivity In activityCollection
Set cStatus = New Status
Set cStatus = cStatus.getStatus(cActivity.Status)
Set cPriority = New Priority
Set cPriority = cPriority.getPriority(cActivity.Priority)
Set cCategory = New Category
Set cCategory = cCategory.getCategory(cActivity.Category)
Set cStream = New Stream
Set cStream = cStream.getStream(cActivity.Stream)
MsgBox cActivity.Title, vbOKOnly, "test"
Me.lbTasks.AddItem ("test" & i)
.Column(i, 0) = cActivity.Title
.Column(i, 1) = cPriority.Label
.Column(i, 2) = cStatus.Label
.Column(i, 3) = cCategory.Label
.Column(i, 4) = cActivity.Budget
.Column(i, 5) = cActivity.StartDate
.Column(i, 3) = cActivity.Deadline
.Column(i, 7) = Switch(cActivity.TicketFlag = 0, "No", cActivity.TicketFlag = -1, "Yes")
.Column(i, 8) = cActivity.SD7
.Column(i, 9) = cActivity.RIE
.Column(i, 10) = cStream.Label
i = i + 1
Next
End With |
Partager