Adding objects as a property of cells/range

[jordan2322]

Hi Guys,

Is there a way that I can store my custom class objects into a hidden attribute of the range class such that I can recall them for use at anytime? perhaps (/not) even after the workbook is closed?

I.e. for each cell in my workbook, can I store a custom object/ collection of custom objects in the cell.

to achieve this would I potentially have to create a new property of the range class (is this possible to do so) or is there perhaps a property/ collection/ etc that already exists that I could simply use for this?

Note, I say I want to store an object to the range class, in fact i may want to store a collection of objects, and even multiple collections to this range. I am just testing the water at this stage to see what information you guys can supply me with.

I would rather use the individual cells to hold the objects, rather than a global collection to hold all the objects. Obvious reasons for this are for recalling purposes. i.e. if i was wanting to retrieve a property from the object that relates to the active cell, I would rather not loop through some global collection of all the objects.

Kind Regards
Jordan

[JosephP]

no you can't. the closest thing I can think of to what you describe would be simply storing the data in a sheet and reading it back into the objects when the workbook opens (or at whatever point you need) or serializing it in some way for storage