Digital Financial Reporting

One of the most frustrating things in my life is getting a treeview control to do what I want in Excel.  Treeview controls seem very illogical to me in VBA.  Now, in VB.Net this is a different story, they make far more sense.

And because of all the trees or hierarchies you have to deal with when working with XBRL, this adds to the frustration.

I can point to two resources which help semi-technical people trying to work with treeviews:

• This is an article which explains the fundamentals of using a treeview control.
• This is an Excel workbook which has a treeview control in it. Someone gave me this code seven or eight years ago and I have used it over, and over, and over.  I modified it slightly to make it easier to use, but it is good code which can be reverse engineered.
• ADDED: Someone sent me this great tutorial on using the treeview control in Micorosoft Access.
• ADDED: Another person sent me this set of tips which is also very helpful.
• ADDED: Another good reference http://mytreeviewblog.blogspot.com/
• ADDED: MSDN http://msdn.microsoft.com/en-us/library/aa443492(VS.60).aspx

If you run across any documentation which explains working with treeview controls in non-technical terms I would really like to have that documentation.