|
发表于 2015-5-19 09:52
|
显示全部楼层
本楼为最佳答案
- Sub 刷新下拉内容()
- Row1 = Sheets("送货明细表").Range("a65536").End(xlUp).Row '“送货明细表”是源数据所在表,“a65536”是源数据所在的列
- Arr1 = Sheets("送货明细表").Range("a3:a" & Row1)
- Set D = CreateObject("Scripting.Dictionary")
- For I = 1 To UBound(Arr1)
- If Not D.Exists(Arr1(I, 1)) Then
- D.Add Arr1(I, 1), ""
- End If
- Next
- s = Join(D.KEYS, ",")
- With Range("B5:B5").Validation 'B5:B5"是所下拉的单元格
- .Delete
- .Add Type:=xlValidateList, _
- AlertStyle:=xlValidAlertStop, _
- Operator:=xlBetween, _
- Formula1:=s
- End With
- End Sub
复制代码 也是借鉴他人的代码,自己瞧瞧看看可否用!! |
|