Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to label an object that persists in memory?
Hi there
In order to keep an object in memory with a know reference point, I typically store it in an element of a public array. Thus, the element number it is stored in becomes a reference point to the object and using this number I can access that specific object's methods through other UDFs. The problem with this though is that it is not particularly neat in that referencing an object in memory via a number offers no description to what the object is. I would much rather be able to attach a (user-defined) label to the object and use that label as a reference point. However, my problem then becomes how to set a pointer from that label to the array element the object is stored in. Does anybody have any ideas that I might try to achieve this labelling process? Thanks very much Lloyd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to label an object that persists in memory?
I would be more inclined to use a collection as opposed to an array...
Public colObjects As Collection Sub PopulateCollection() Set colObjects = New Collection colObjects.Add Sheet1, "MySheet" colObjects.Add Range("A1:B2"), "MyRange" MsgBox colObjects("MySheet").Name MsgBox colObjects("MyRange").Address End Sub -- HTH... Jim Thomlinson "pinkfloydfan" wrote: Hi there In order to keep an object in memory with a know reference point, I typically store it in an element of a public array. Thus, the element number it is stored in becomes a reference point to the object and using this number I can access that specific object's methods through other UDFs. The problem with this though is that it is not particularly neat in that referencing an object in memory via a number offers no description to what the object is. I would much rather be able to attach a (user-defined) label to the object and use that label as a reference point. However, my problem then becomes how to set a pointer from that label to the array element the object is stored in. Does anybody have any ideas that I might try to achieve this labelling process? Thanks very much Lloyd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to label an object that persists in memory?
It's not very clear what you are doing or trying to do, but have you
considered a user-defined type? You could include a description as one of its elements. You can also declare an array of this type. Hth, Merjet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to label an object that persists in memory?
Gotcha,
So you can store the object in a collection and then attach a label to it to describe it by... That might work although I will have to re-write my UDFs to access the various methods via the collection first, but that seems ok. Cheers Lloyd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Passing a Label object to another procedure | Excel Programming | |||
How to create a Delete method which frees memory occupied by my object | Excel Programming | |||
Remove object from memory | Excel Programming | |||
macro warning persists even after deleting all macros | Excel Discussion (Misc queries) |