|
发表于 2012-1-12 08:36
|
显示全部楼层
本楼为最佳答案
本帖最后由 sunjing-zxl 于 2012-1-12 08:40 编辑
arr = d.Keys()
str = Join(arr, ",")
Formula1:=str--------------------(数据有效性的引用)
Sub aa()
Dim arr
Dim i As Long, str As String
Dim d As New dictionary
arr = Range("a1:a14")
For i = 1 To UBound(arr)
d(arr(i, 1)) = d(arr(i, 1)) + 1
Next i
arr = d.Keys()
str = Join(arr, ",")
With Range("b1:b10").Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=str
End With
End Sub
|
|