Treelist

Tree List uses hierarchical data to create lists of Items in an Excel Worksheet that can expanded and collapsed at Parent Nodes. When the Nodes are expanded or collapsed any descendants that are already expanded or collapsed persist. The finished list can be copied into a new Workbook or an existing Project - all of the Code is generated in a self-contained "Template" Worksheet Code Module - just Copy out the Worksheet to use the new Treelist. Treelist also supports Office 365 Subscription Icons

Tree List can be used to create many kinds of lists, including a Hyperlink Index to other Worksheets or Web Pages, a T.O.C. or an Options / Settings list. Tree List is highly configurable. You can change the position of the Tree List, change the Node Type and Colours, choose whether or not to draw the Node hairlines, choose whether or not to add the Buttons and Code to expand or collapse all of the Items at once and much more

Features include:

• Create an expandable and collapsible Tree List in an Excel Worksheet with associated VBA Code from a list of Items
• The Tree List "Template" Worksheet can be renamed and copied into a new or existing Workbook
• Use Text, Dates, Numbers, Hyperlinks or Styles to format the Tree List Items
• Change Standard Node Icons to different Icons ie. Warning, Magnify, Setup etc.
• Use SVG/Graphics Icons with Standard Nodes for Toggling
• Use Office 365 Icons as Toggle Nodes
• Use SVG Icons, having both Fill Colour & Outline Colour for Toggle Nodes and ExpandAll/CollapseAll Nodes
• Change the Width and Height of the Icons for Toggle Nodes and Standard Nodes
• Create the Tree output to start at any Row or Column
• Set the Tree List Column & Row Widths
• Set the Tree List Background Colour - the Icons are transparent
• Choose the Node Hairline Colour or whether or not to draw the Node Hairlines
• Choose the Node Hairline Line Style and Border Weight
• Choose the Expandable & Collapsable Node Types, either Folders, Squares or Triangles
• Change the Horizontal & Vertical Toggle Node and Standard Node positioning
• Run a DeleteEveryOtherRow() Macro after a Treelist Build to create a Single Line Treelist
• Choose Row Banding and set the Banding Colour
• Tree Node &lder Icons visually indicate collapsed or expanded Item
• Options are included to write out the VBA Code to collapse and expand all of the items at once
• Add a subtle Click Effect Animation to the Treelist Nodes when they are clicked
• Protect Nodes from Selection but still allow Worksheet editing
• Choose whether or not to link Standard Nodes to the Toggle Code Macro
• Move a Treelist after a Build either down or up through Worksheet Rows or left and right across Worksheet Columns
• Choose whether or not to Merge Cells for Treelist Node Text
• Adjust the Height & Width of Standard, Toggle Nodes and ExpandAll/CollapseAll Nodes
• Run Macro after Build allows you to add you own Code to perform some formatting following a Treelist Build
• Use one of the Quick Styles to change the style of the Treelist rendered including new Professional Light Theme
• Use alternate Row Colours for Toggle Nodes and Standard Nodes
• Skeleton - an Options Sheet Theme Creator to build 2-tier Menus in two Colours, dark and light
• Load a 2 Column list that can be maintained and Sorted on a TreeStructure Sheet directly into the TreeList Sheet

Youtube Video:

Treelist Video

More Information:

Treelist Online Legacy Documentation

The Paid Download File includes all of the Treelist Demo Excel Workbooks.  The second Video at the top of the Page is a Video showing a Template created using my built-in Skeleton Theme Creator for Treelist, in a Dark Mode as well as a Light Mode; take a look.  It demonstrates using a clickable navigation Link and Cut & Paste of Rows to quickly extend the Treelist Nodes.  Have fun creating your Treelists ...