VBA 从数组创建字典
Function range2dict(keyarr, valarr) As Scripting.DictionaryDim mydict As ObjectDim i, key, valSet mydict = CreateObject("scripting.dictionary")For i = 1 To UBound(keyarr) - LBound(keyarr) + 1key = keyarr(i)val = valarr(i)'Debug.Print key, valIf Not mydict.exists(key) Thenmydict.Add key, valEnd IfNextSet range2dict = mydictEnd Function
经测试,第一条代码报错:用户定义类型未定义
