|
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- If Target.Count > 1 Then Exit Sub
- Dim Myr&, Arr, i&, Arr1, j&
- If Target.Address = "$C$3" Then
- Myr = [a65536].End(xlUp).Row
- Arr = Range("a15:b" & Myr)
- ReDim Arr1(1 To UBound(Arr), 1 To 2)
- j = j + 1
- Arr1(1, 1) = "科目代码": Arr1(1, 2) = "科目名称"
- For i = 1 To UBound(Arr)
- If Left(Arr(i, 1), 4) = CStr(Target.Value) Then
- j = j + 1
- Arr1(j, 1) = Arr(i, 1): Arr1(j, 2) = Arr(i, 2)
- End If
- Next
- With Me.ListBox1
- .Visible = True
- .Top = [c4].Top
- .Left = [d3].Left
- .ColumnCount = 2
- .ColumnWidths = "60,50"
- .Clear
- .List = Arr1
- End With
- Else
- Me.ListBox1.Visible = False
- End If
- End Sub
复制代码 |
|