MSForms treeview

[Jan Karel Pieterse]

Hi all,

If you have ever used the Treeview control from the "Additional controls" section, then you know what a versatile control this is to show hierarchically organized data.

There are a couple of problems with this treeview control:

1. You always risk compile errors due to a difference in versions of the common controls library. For example, if you design the userform on 64 bit windows, people using 32 bit windows will probably get compile errors because the reference to the common controls library appears missing for them. They can use the treeview, but have to set the reference to the proper version (theirs) of the library.

2. The control is unavailable for 64 bit versions of Office.

Especially the second point convinced me it is time to develop a custom-made treeview "control", that only uses the native Office forms controls. I started building this a couple of weeks ago and after some time I tricked Peter Thornton into helping me with it.

As soon as the "control" is fit for publishing I'll post here.

Screenshot:

treeview07.gif

[HansV]

That sounds very interesting - I'm looking forward to seeing it in action!

[Jan Karel Pieterse]

I've made a blog post about this here:
http://dailydoseofexcel.com/archives/20 ... -treeview/
Watch that blog, I'll post there once we're done.

[HansV]

Thanks, I'll keep an eye on it.