|
Option Explicit
Private Sub ComboBox1_Change()
Dim ITM As ListItem, j&, k&
ListView1.ListItems.Clear
For i = 2 To [A65536].End(xlUp).Row
If Cells(i, 1) = ComboBox1.Text Then
Set ITM = ListView1.ListItems.Add()
ITM.Text = Cells(i, 1)
ITM.SubItems(1) = Cells(i, 2)
ITM.SubItems(2) = Cells(i, 3)
ITM.SubItems(3) = Cells(i, 4)
End If
Next i
End Sub
在上述代码中增加And或or判断 如果按钮选项为A1 or D1,ListView中的显示数据,进一步精确。
|
|