Treeview Control Article

Over the last couple of nights, I've decided to create a VBA project, and in doing so worked with the Treeview control.  One thing I found frustrating was a lack of very simple information on how to set it up, so I decided to write up an article on it.  You can find that right here.

I'm curious to know other's thoughts on both the article and the control.  I do appreciate that it is a little bit long, but if you've never used one before, and you know how to code a little, I'm hoping that it will explain enough for people to understand how it works.  Even better would be if it is good enough that people could easily adapt it to their own work.

So what do you think?  For the intermediate level coder, is it too dumbed down, or...?

🙂

6 thoughts on “Treeview Control Article

  1. I was under the impression that the Common Controls Treeview was not redistributable unless contained within a compiled executable (i.e. NOT VBA). I haven't yet read your article, so maybe you point this out, but it's something for others to bear in mind.

    BTW, I know you're getting into .NET, so you'll be pleased to know that the WinForms treeview control has a much more intuitive object model.

  2. Hi Rob,

    I don't believe that's the case with the redistribution. I could be corrected on this, but my friend Jan Karel Pieterse distributes his name manager add-in as an xla file.

    I'm looking forward to using it in .Net as well, although that will be a little ways off yet, I think. 🙂

  3. Hey Ken,

    Nice article and great reference to Colo's site! Bookmarked it for future reference =)

    I don't think the article is dumbed down too much. It's tough to define Intermediate from Beginner when it comes to VBA. That said, I think you covered the necessary information for the topic.

    Although I did notice some typos in the article. Nothing major, just a few things =)

  4. You're right Ken. I finally managed to find a machine without VB6 installed to test this (my daughter's; now I'm dead) and it works fine.

    These controls never used to work in Office (except Access), so I must conclude that MS has changed its licensing policy, which is very sensible of them.

  5. Great stuff, Rob. Thanks for confirming!

    I'm curious if the issue might exist for older versions of Office, though. I actually have a product in build right now that I will be testing (although it may be a while). I'll post back when I've tested it in a 2000 environment.

If you have a comment or question about the blog post content, please feel free to post it here. If you need help adapting this solution to your own needs, please post in our free help forum.

Your email address will not be published. Required fields are marked *