- Private Sub UserForm_Initialize()
- ListView1.ColumnHeaders.Add , , "mc", 40, lvwColumnLeft
- ListView1.ColumnHeaders.Add , , "料号", 100, lvwColumnCenter
- ListView1.ColumnHeaders.Add , , "吸着", 80, lvwColumnCenter
- ListView1.ColumnHeaders.Add , , "错误", 80, lvwColumnCenter
- ListView1.ColumnHeaders.Add , , "错误率[%]", 80, lvwColumnCenter
- ListView1.View = lvwReport
- ListView1.FullRowSelect = True
- ListView1.Gridlines = True
- End Sub
- Sub optionbutton1_CLICK()
- ListView1.ListItems.Clear
- For i = 2 To 11
- Set Itm = ListView1.ListItems.Add()
- Itm.Text = Sheet2.Cells(i, 1)
- Itm.SubItems(1) = Sheet2.Cells(i, 2)
- Itm.SubItems(2) = Sheet2.Cells(i, 3)
- Itm.SubItems(3) = Sheet2.Cells(i, 4)
- Itm.SubItems(4) = Sheet2.Cells(i, 5)
- Next
- End Sub
- Sub optionbutton2_CLICK()
- ListView1.ListItems.Clear
- For i = 2 To 11
- Set Itm = ListView1.ListItems.Add()
- Itm.Text = Sheet1.Cells(i, 1)
- Itm.SubItems(1) = Sheet1.Cells(i, 2)
- Itm.SubItems(2) = Sheet1.Cells(i, 3)
- Itm.SubItems(3) = Sheet1.Cells(i, 4)
- Itm.SubItems(4) = Sheet1.Cells(i, 5)
- Next
- End Sub
复制代码 已经用笨方法实现了 哪位还有更简洁的?
|