我想让查询到AL列,可是到了K列就不动了,后面的数据引用不不来了,咋办?谢谢了
Private Sub ComboBox1_Change()
Dim xm$, i&, j&, aa
xm = ComboBox1.Text
With Me.ListBox1
.Clear
.ColumnCount = 20
.ColumnWidths = "35,30,30,30,30,30,30,30,30,30"
For i = 0 To UBound(k)
If xm = k(i) Then
t(i) = Left(t(i), Len(t(i)) - 1)
If InStr(t(i), ",") Then
aa = Split(t(i), ",")
For j = 0 To UBound(aa)
.AddItem
.List(j, 0) = arr(aa(j), 1)
.List(j, 1) = arr(aa(j), 2)
.List(j, 2) = arr(aa(j), 3)
.List(j, 3) = arr(aa(j), 4)
.List(j, 4) = arr(aa(j), 5)
.List(j, 5) = arr(aa(j), 6)
.List(j, 6) = arr(aa(j), 7)
.List(j, 7) = arr(aa(j), 8)
.List(j, 8) = arr(aa(j), 9)
.List(j, 9) = arr(aa(j), 10)
Next
Else
.AddItem: j = 0
.List(j, 0) = arr(t(i), 1)
.List(j, 1) = arr(t(i), 2)
.List(j, 2) = arr(t(i), 3)
.List(j, 3) = arr(t(i), 4)
.List(j, 4) = arr(t(i), 5)
.List(j, 5) = arr(t(i), 6)
.List(j, 6) = arr(t(i), 7)
.List(j, 7) = arr(t(i), 8)
.List(j, 8) = arr(t(i), 9)
.List(j, 9) = arr(t(i), 10)
End If
End If
Next
End With
End Sub
改了一下,把地名和日期全部放到ListBox里面去。
|