Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
update collection of arrays
Is it possible to update the value of an array element if that array is held
by a collection? It seems not: Sub test2() Dim oColl As Collection Dim arr(1 To 10) Set oColl = New Collection arr(1) = 5 oColl.Add arr, "a" MsgBox oColl(1)(1) oColl(1)(1) = 6 MsgBox oColl(1)(1) End Sub Is there any solution for this? The whole purpose is to store data with nodes of a treeview control and to have a robust linkage between the nodes and the stored data. RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
canceling the formula aut-update feature with Arrays | Excel Discussion (Misc queries) | |||
Compare and update arrays | Excel Programming | |||
Range collection | Excel Programming | |||
Collection | Excel Programming | |||
Is a Collection the best option? | Excel Programming |