How to create collections & objects from range

[SAGAR KHOLLAM]

A B C D
1 Collection Property 1 Property 2 Property 3
2 object1
3 object2
4 object3

How to make objects and collection from worksheet range?

Suppose the name of collection is at ("A1"), objects in Column "A", and properties of objects in first row.


thanks in advance

[Tartarus]

I don't think that you could easily declare the name of a collection on a worksheet. It would have to be in the code. However, the rest of your idea should be feasible. After refreshing my own knowledge with 45 minutes of research I have reached the conclusion that a custom class will be the best solution, for reasons you only find out after you have set up everything in a way that appeared easier at first. I would follow the advice of Chip Pearson in this case. You may follow this link,

Please Login or Register  to view this content.

[SAGAR KHOLLAM]

Thanks for the effort taken, I had gone through the link, but not sure how it will work for my problem.

[Tartarus]

Try to apply it and share the difficulties you encounte, if any.

[Kyle123]

Normally I'd agree that a collection of classes would be best as suggested, however that would require you to know all your properties in advance where you might not.

A collection of collections offers more flexibility, that said, I don't think you've provided enough information to go on, what do you want to do with the data? That will dictate the approach you take.

Example collection of collections:

Please Login or Register  to view this content.

[SAGAR KHOLLAM]

Thanks for your reply.
First i will develop code which i will implement on user form later on.
As there are many input table, I want a micro which will generate objects with property on which am going to implement method. Also I want the objects which are created to be box data type, so there will not be any mismatch
In attached sheet, the solver in code will generate mass, volume etc. values these values are compared with available list value.
As my program to be generic so am using Object-oriented programming (OOP)

[Kyle123]

Sorry, I've really no idea what you're trying to do.

Why are you trying to make things object orientated? You've got some really random unrelated classes in your workbook.

[SAGAR KHOLLAM]

It seems very difficult, i should drop idea of making objects from range.