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.