|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Private Sub Worksheet_Change(ByVal T As Range)
If T.Row = 9 And T.Column = 2 Then
Set Rng = Sheets("数据").Columns(1).Find(T.Value, , , 1)
If Not Rng Is Nothing Then
r = Rng.Row
ar = Sheets("数据").Range("b" & r & ":g" & r)
For j = 1 To UBound(ar, 2)
If Trim(ar(1, j)) <> "" Then
If s = "" Then
s = ar(1, j)
Else
s = s & "," & ar(1, j)
End If
End If
Next j
With Range("e9").Validation
.Delete
.Add 3, 1, 1, Formula1:=s
End With
T.Offset(, 2).Select
End If
End If
End Sub
|
|