|
本帖最后由 爱疯 于 2013-7-3 12:14 编辑
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim d, A, i, x
If Target.Column = 1 Or Target.Count > 1 Then End
x = Target.Offset(0, -1)
If x = "" Then End
A = Sheet1.Range("A1").CurrentRegion
Set d = CreateObject("Scripting.Dictionary")
For i = 1 To UBound(A)
If x = A(i, 1) Then
d(A(i, 2)) = ""
End If
Next i
With Target.Validation
.Delete
.Add Type:=xlValidateList, Formula1:=Join(d.keys, ",")
End With
End Sub
动态数据有效性2.rar
(14.64 KB, 下载次数: 11)
|
|