|
直接修改后的代码
- Private Sub UserForm_Initialize()
- Debug.Print "init"
- ComboBox1.RowSource = Sheets("1").Range("队名").Address '修改的代码'
- ComboBox2.Enabled = False
- ComboBox2.BackColor = &H8000000F
- On Error Resume Next
- Dim i As Integer, X As Integer, Y As Integer
- With ListView1
- .Sorted = False
- .ColumnHeaders.Clear
- .ListItems.Clear
- .Gridlines = True
- .HideColumnHeaders = False
- .View = lvwReport
- .SortKey = 0
- End With
- For i = 4 To 13
- ListView1.ColumnHeaders.Add , , Sheet2.Cells(1, i), Width:=Sheet2.Cells(1, i).Width
- Next i
- With Sheet2
- X = .Range("d65536").End(xlUp).Row
- arrData = .Range("d2:m" & X)
- End With
- Set dsD = CreateObject("Scripting.Dictionary")
- For i = 1 To UBound(arrData)
- dsD.Add arrData(i, 4), i '1
- With ListView1.ListItems.Add(, , arrData(i, 1))
- For Y = 2 To UBound(arrData, 2)
- If Y = 5 Then arrData(i, Y) = Format(arrData(i, Y), "hh:mm:ss") '添加的代码
- .SubItems(Y - 1) = arrData(i, Y)
- Next Y
- End With
- Debug.Print i
- Next i
- ComboBox2.List = dsD.keys
- End Sub
复制代码 |
|