See your forest-through-the-trees with the TreeView control. This new control makes it easy to display information in a hierarchical fashion and expand and hide nested rows at runtime. Like the ListBox, the TreeView control uses many of the same control properties and VBA Language Extensions, but also uses a new variable type called “vbaRow”.
The Bill of Materials Pick List is an example generated from the TreeView control. It’s a Bill of Materials for assembling a "Waterfall Picture Kit" and shows the location of the parts and materials.
The parent rows (rows which will contain child rows) are constructed by declaring the row names as “vbaRow” and by using the Set command to specify where the parent is added.
Here are the steps for how the rows and sub-rows were created: