|
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim ar, br(1 To 3), st
- Dim i As Byte
- If Target.Address <> "$A$22" Then Exit Sub
- Range("b22:d22").ClearContents
- ar = Range("a3:d18")
- st = Target.Value
- For i = 1 To UBound(ar)
- If ar(i, 1) = st Then
- br(1) = ar(i, 2)
- br(2) = ar(i, 3)
- br(3) = ar(i, 4)
- Range("b22:d22") = br
- Exit Sub
- End If
- Next
- End Sub
复制代码
查询问题.rar
(6.89 KB, 下载次数: 5)
|
|