Icons in TreeView Control

**jfmorales** · 10-24-2011, 08:05 PM

I have a workbook that displays a form with a TreeView control. I'd like to assign various icons to different nodes in the tree. Based on the article at http://msdn.microsoft.com/en-us/libr...(v=VS.80).aspx, it appears that I need to read images from external files into an image list, which can then be referenced from the ImageIndex or IndexKey property of individual tree nodes.

However, I also want my workbook to be portable, so I can E-mail it to someone and they can view it on their system and see the same things that I do. This doesn't seem consistent with the requirement to read in the icon files from a separate location, since in that case I need to distribute extra image files with the workbook and make sure they get installed in some known location.

Is there some way of storing images with the Excel workbook itself and accessing them for use within a TreeView control on a form?

Thanks.

**Leith Ross** · 10-24-2011, 08:09 PM

Hello jfmorales,

The link you referenced is for "VB.NET". Are you using VB.NET or VBA? They are two very different languages.

**jfmorales** · 10-27-2011, 01:43 PM

>> The link you referenced is for "VB.NET". Are you using VB.NET or VBA? They are two very different languages. <<
I meant VBA. When I do searches on the TreeView control, it often takes me accidentally to different versions for different languages. Thanks, Joseph

**Leith Ross** · 10-27-2011, 02:37 PM

Hello jfmorales,

VBA can use icons in a Tree View control. You have to create an ImageList object that contains the pictures you want to display. The ImageList has a property ListImages that points to a ListImages collection object. This contains the ListImage pictures. The ListImage Picture property can be set to the picture you want by using the VBA LoadPicture method.

The downside of this is you can not save the ImageList object as a resource file. If you want to use this on another computer then all the picture files have to be transferred also.