ExcelBanter - dictionary-(item, item, item); Can dictionary point to an array inVBA?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - dictionary-(item, item, item); Can dictionary point to an array inVBA? (https://www.excelbanter.com/excel-programming/440327-dictionary-item-item-item-%3B-can-dictionary-point-array-invba.html)

cate

dictionary-(item, item, item); Can dictionary point to an array inVBA?

Is it possible to have a dictionary object point to an simple array?

Can you do something like that in code?

Tim Williams[_2_]

dictionary-(item, item, item); Can dictionary point to an array in VBA?

Dim oDict as new Scripting.Dictionary

oDict.Add "key_value", Array("foo", "bar")

Tim

"cate" wrote in message
...
Is it possible to have a dictionary object point to an simple array?

Can you do something like that in code?

All times are GMT +1. The time now is 10:31 PM.