Private Sub UserForm_Initialize()
Dim X As Integer
X = Sheets("产量").Range("A65536").End(xlUp).Row
If X < 3 Then Exit Sub
ComboBox4.List = ADD_COMB_ARR(Range("A3:A" & X))
ComboBox5.List = ADD_COMB_ARR(Range("C3:C" & X))
ComboBox6.List = ADD_COMB_ARR(Range("D3:D" & X))
ComboBox7.List = ADD_COMB_ARR(Range("E3:E" & X))
ComboBox8.List = ADD_COMB_ARR(Range("F3:F" & X))
ComboBox9.List = ADD_COMB_ARR(Range("G3:G" & X))
End Sub
Function ADD_COMB_ARR(Target As Range) '自定义函数 得到不重复内容(数据单元格区域)
Dim Ran As Range
Dim D As New Dictionary
For Each Ran In Target
D(Ran.Text) = ""
Next
ADD_COMB_ARR = IIf(D.Count > 0, D.Keys, Array(""))
End Function
请问为什么我用这个代码会提示Dim D As New Dictionary用户定义类型未定义,该如何解决