Your Favorite Treeview codes and examples

**pike** · Nov 5th 2017

Hi All,
Someone may find these two examples helpful .. still one "On error resume Next" to debug and remove in the search option. The Filter and the data is a bit mixed up but proper data and Criteria1 will work for filter treeview.
interested if you can share any examples you have, tools or ideas.

JoaoM · Nov 5th 2017

Sorry, it's not what I thought.

**royUK** · Nov 5th 2017

Nice work Pike. Here's one that uses an ImageList to display pictures. You can adapt to display a folder image for the Nodes

**iwrk4dedpr** · Nov 6th 2017

Looks pretty cool ... Will have to keep this in mind for future projects.

Tom.Jones · Nov 6th 2017

Hi,

I get "run time error 481"
Invalid pictures

How can I pass from that?
Thanks.

**pike** · Nov 6th 2017

Are you working in 64 bit Roy?

**royUK** · Nov 6th 2017

No 32 Bit, if the images folder is in the same folder as the listview workbook there should be no issues. It was working fine yesterday, I added and removed images. I'll check again when I get home

**royUK** · Nov 6th 2017

I've looked at this issue and ico files are definitely supported by LoadPicture. This example uses a UDF by Stephen Bullen

Tom.Jones · Nov 6th 2017

Thank you Roy,
This one work.
Treeview-Example-Simpsons GDI.xlsm (105.4 KB)

**pike** · Sep 3rd 2018

Treeview and popup class combined to create list of materials or Bill Of Materials

Pick the qty and assembles from the treeview to build a assemblies list on the worksheet.
in treeview - Right click on the last node to view a breakdown of assembly items

Click command button on worksheet to Generate a list of materials or pick list of items for the selected assemblies

Your Favorite Treeview codes and examples

Participate now!

Share