How to create collections & objects from range

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

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,

Formula:

http://www.cpearson.com/excel/CollectionClass.aspx

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

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

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:

Sub Kyle()

    Dim rng As Variant: rng = Sheets(1).Cells(1, 1).CurrentRegion.Value
    Dim obj As Object
    Dim lRow As Long, lCol As Long
    Dim Objects As Collection
    Dim ObjectProps As Collection
    Set Objects = New Collection
    
    For lRow = 2 To UBound(rng)
        Set ObjectProps = New Collection
        For lCol = 2 To UBound(rng, 2)
            ObjectProps.Add rng(lRow, lCol), rng(1, lCol)
        Next lCol
        Objects.Add ObjectProps, rng(lRow, 1)
    Next lRow
    
    
    'Loop through all objects
    For Each obj In Objects
        Debug.Print obj("Property 1")
        Debug.Print obj("Property 2")
        Debug.Print obj("Property 3")
    Next obj
    
    'Access specific object and property
    Debug.Print Objects("object2")("Property 1")
    Debug.Print Objects("object1")("Property 3")
    
End Sub

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)

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.

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