Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collection Look Up - By Key in an Excel VBA App.
Hi,
I have used a collection to store a set of Objects that I need to look up by the Key value... Like Dim c As Collection Set c=New Collection c.Add Obj, Obj.Key Neither of these seem to work- Key = c(Obj.Key) Or Key = c.Item(Obj.Key) Although the help on the VBA Collection object behaviour seems to support either of these two types of Look Up. Is there some Version / Application Dependency that i might be mnissing here? Also I had to replace the collection with a dictionary for this to work. My observation has been that "Add" into a Dictionary is slower compared to a collection. The Lookup I havent been able to compare, since I havent been able to Look up an Obj by key from a collection. Help / Ideas, Please? Thanks in Advance, Megha. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collection Look Up - By Key in an Excel VBA App.
This was just an example to say
Public c As Collection Sub A Dim Obj As Class1 Set Obj = New Class1 .... Some settting of values and key Set c=New Collection c.Add Obj, Obj.Key End Sub Sub B( Key As String) Dim Obj As Class1 Set Obj=c(Key) --- this is not working 'Set Obj=c.Item(Key) --Neither is this End Sub -Megha |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collection Look Up - By Key in an Excel VBA App.
That's a technique that I've implemented any number of times. It
works. If you would like someone to help you, you need to provide the code that doesn't work, not just unconnected snippets. What is the type of Class1's Key? What is the value of Obj.Key when you add the object to the collection? How are A and B related? When and in what sequence are they called? What is the value of B's argument Key when it doesn't work? -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article .com, says... This was just an example to say Public c As Collection Sub A Dim Obj As Class1 Set Obj = New Class1 ... Some settting of values and key Set c=New Collection c.Add Obj, Obj.Key End Sub Sub B( Key As String) Dim Obj As Class1 Set Obj=c(Key) --- this is not working 'Set Obj=c.Item(Key) --Neither is this End Sub -Megha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel data collection | Excel Discussion (Misc queries) | |||
Excel 2003 macro collection | Excel Discussion (Misc queries) | |||
how do i create a data collection form in excel? | New Users to Excel | |||
excel columns collection? | Excel Programming | |||
Keybindings Collection in Excel | Excel Programming |