• Home
• News
• Newsletter
• Events
• Headlines
• Products
• Excel Training
• Recommendations
• Services
• Articles
  • add-in Installation
  • Add-ins do not load
  • API declarations
  • Build Excel Add-in
  • Catch Paste
  • Chart an Equation
  • Challenges
  • Circular References
  • Co-Authoring
  • Control Events
  • Controls
  • Corrupt Files
  • Create add-ins
  • Custom Find
  • Data Types
  • Data Entry Help
  • Defined Names
  • Disable Events
  • Docking VBE Windows
  • Excel 2007 FileFormat
  • Drag And Drop
  • Excel data table recipe
  • Excel Tables
  • Excel Tables (VBA)
  • Excel Web App Mashups
  • Fix Links to UDFs
  • Formula Wrapper
  • Import textfiles
  • Inventory System
  • Keep Userform On Top
  • Listbox AutoSize
  • Least Squares
  • Object Lister
  • Pivottable Slicers
  • Performance Class
  • Prevent Open Event
  • Register UDFs
  • Round2Digits
  • Select a range (VBA)
  • Show Picture
  • Spreadsheet Template
  • Startup Problems
  • Styles in Excel
  • Transpose Table
  • Treeview control
    • Features
    • How To Use
    • Examples

    ---

  • Undo With Excel VBA
  • Update An add-in
  • WebQuery
  • Wheel of Fortune
  • Workbook Open Bug
  • XML and Excel
• Books
• Reviews
• Downloads
• Links
• Contact
• Privacy Policy
• Site map

Subscribe in a reader

Audit !!!

Trainings

Third party tools

Speed up your file

What has changed?

An MSForms (all VBA) treeview; How to use

This page outlines the minimum steps needed to add this treeview control to your own Excel or Word VBA project. For Access the instructions are different, those can be found in the Access download.

The container control

Open the designer window of your userform and add a frame. This is where the treeview will be built. We recommend these properties (which are of course optional):

 
Recommended properties for the container frame

Your userform would look like this:

 
The container frame on your userform

If you want images in your treeview, you'll have to add another frame (we called it frmImageBox) and then add Image controls within that frame. Set the Visible property of the frame to false to avoid it showing up on your userform. Like so:

 
The images frame on your userform

If you want to add images, make sure you name the new image controls properly, as it is the name of the imagecontrol you need to pass to the cNode class to get that image displayed. An easy way to get the images is to copy the entire frame with images from our userform to yours.

Class modules

Copy the class modules clsNode and clsTreeView to your project (you can simply drag them to your project). Your project (if you started with an empty workbook) would look like this:

 

The project with class modules in place

So far, things have been simple. The next parts are a bit more compex, but nothing too hard!

Code behind your userform

For the treeview to work, your userform needs some code, in particular these elements are necessary:

• Some variable declarations that will enable you to address the treeview and have your form handle events
• Initialisation code to:
  • add nodes to the tree
  • draw the treeview

That's it!

Variable declaration

Add this code to the declaration section of your userform:

That's it! No more variables needed!

Of course the name of the variable mcTree is totally up to you.

If you need another (independent) treeview on your form, simply add another frame to hold it and an additional variable in the forms declaration section (of course you name it differently than the other one) like the one shown here.

Initialisation

In the intialisation routine of your form, you need code that adds nodes to the tree and when you're done adding nodes, you need to set some properties of the treeview. Then you'll want the treeview to be displayed.

Adding an instance of the treeview to your form

Adding the instance is easy:

Now tell the tree class instance which frame is its container:

Note that most of the code listed below is within the With mcTree ... End With structure.
 

Setting initial look

You'll want control over the look and feel of your treeview, here is some example code (this code comes immediately below the code sample show above):

If your treeview needs to show images, add a frame control with Image controls inside. Lets call it frmImageBox. This is how you tell the class where the images are:

That is just about all the plumbing you need to get started.

Adding nodes

First of all, a couple of variables are needed to add nodes:

Next we'll start by building the rootnode:

Note that the tree can have more than one rootnode, there is a special RootNodes collection to which you automatically add new roots by calling the AddRoot method.

As you can see, we assume there are two icons in the image frame called FolderClosed and FolderOpen respectively.

Now we want to add children to the root. This is the code from our demo form:

Display the tree

Displaying the tree is as simple as calling one method:

Termination

When the form goes out of scope (i.e. out of memory) you need to remove the treeview from memory:

Feedback

We've worked hard to create a reliable and performant treeview. If you encounter bugs, please let us know so we can work on them. Better yet: if you have fixed a bug you found, send us your updated code so we can add the fixes you made.

In any case, comments (and compliments) are welcome!

  Prev: Features

Next: Examples