To sort by a property in the object, you have to specify a comparer or a method to get that property. Using the List.Sort method: theList.Sort(Function(x, y) x.age.CompareTo(y.age)) Using the OrderBy extension method: theList = theList.OrderBy(Function(x) x.age).ToList()

When sorting using VBA, you need to use the Range.Sort method in your code. The ‘Range’ would be the data that you’re trying to sort. For example, if you’re sorting the data in A1:A10, then ‘Range’ would be Range (“A1:A10”). You can also create a named range and use it instead of the cell references.