The hierarchical listbox is an class object that allows you to turn a normal userform listbox into a treeview style listbox; with fully working node collapsing and expansion.
I have created this example with a set of options so you can experiment with the appreance of the node connecting lines and the open/closed status; fixed and proportional fonts.
The example has 25 items stored in varying structures to demonstrate the flexibility.
Hopefully you will find this useful as well as interesting.
Feedback is welcomed.
This example will only work in xl2000 or higher because I have used RaiseEvent.
I have written a xl97 version that uses module calls instead, which could be posted later.