|
For i = 2 To UBound(arr)
得从3开始计数。- Private Sub UserForm_Initialize()
- Dim arr, i&, n%
- Me.Caption = "证件到期提醒"
- arr = Sheets("Sheet1").Range("A2").CurrentRegion
- With ListView1
- .ColumnHeaders.Add , , arr(1, 1), .Width / 4, lvwColumnLeft
- .ColumnHeaders.Add , , arr(1, 2), .Width / 4, lvwColumnCenter
- .ColumnHeaders.Add , , arr(1, 3), .Width / 4, lvwColumnCenter
- .ColumnHeaders.Add , , arr(1, 4), .Width / 4, lvwColumnCenter
- .View = lvwReport
- .Gridlines = True
- .FullRowSelect = True
- For i = 3 To UBound(arr)
- If DateDiff("d", Replace(arr(i, 4), ".", "-"), Date) >= 365 Then
- With .ListItems.Add(Text:=arr(i, 1))
- For j = 1 To 3
- .SubItems(j) = arr(i, j + 1)
- Next
- End With
- End If
- Next
- End With
- End Sub
复制代码 |
|