|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Dim arr, d As Object, i&
- Private Sub UserForm_Initialize()
- Set d = CreateObject("Scripting.Dictionary")
- arr = Sheet1.Range("A1").CurrentRegion
- On Error Resume Next
- For i = 2 To UBound(arr)
- If Not d.Exists(arr(i, 1)) Then
- d(arr(i, 1)) = i
- Else
- d.Item(arr(i, 1)) = d.Item(arr(i, 1)) & "|" & i
- End If
- Next
- ListBox1.List = d.keys
- End Sub
- Private Sub ListBox1_Click()
- Dim t, N%, a(1 To 10, 1 To 8)
- For Each t In Split(d.Item(ListBox1.Text), "|")
- N = N + 1
- If N = 1 Then
- Range("A3") = "完工日期:" & arr(t, 2)
- Range("E3") = arr(t, 9)
- Range("G3") = arr(t, 1)
- End If
- a(N, 1) = N
- a(N, 2) = arr(t, 3)
- a(N, 3) = arr(t, 8)
- a(N, 4) = arr(t, 4)
- a(N, 5) = arr(t, 5)
- a(N, 6) = arr(t, 6)
- a(N, 7) = arr(t, 7)
- Next
- Sheet2.Range("A5:H14") = a
- cmd打印.Enabled = True
- End Sub
- Private Sub cmd打印_Click()
- Sheet2.Range("A1:H16").PrintOut
- End Sub
复制代码 |
|