|
发表于 2013-11-26 14:37
|
显示全部楼层
本楼为最佳答案
假绅士 发表于 2013-11-26 14:30
那用代码怎么做啊?可以支持我在“名单”中后续填充数据吧?
B2的公式=IFERROR(VLOOKUP(B3,名单!A:B,2,),"")
以下代码当你选择B3时运行得到下拉- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim arr, brr(), x%, j%, str1$
- If Target.Address = "$B$3" Then
- arr = Sheets("名单").UsedRange
- str1 = Range("B1").Value
- For x = 1 To UBound(arr)
- If Mid(arr(x, 2), 7, 4) = str1 Then
- i = i + 1
- ReDim Preserve brr(1 To i)
- brr(i) = arr(x, 1)
- End If
- Next x
- If i = 0 Then
- Target.Validation.Delete
- Target.Value = ""
- Exit Sub
- End If
- With Target.Validation
- .Delete
- .Add Type:=3, Formula1:=Join(brr, ",")
- End With
- End If
- End Sub
复制代码 |
|