PDA

Click to See Complete Forum and Search --> : Resolved[Trees in Vba]


Fonty
Jun 20th, 2006, 10:35 AM
I'm doing a userform which scans the content of some directories. At this moment I can see their content in a list box, through exploring the folders with combobox which are sequentially filled from some pivot tables... It's a mess but it works.
Is it possible to visualize a tree in a user form, like one of those in windows explorer, so that you can see the directory folders?

Static
Jun 20th, 2006, 10:50 AM
Right click the toolbox.. additional controls - Microsoft Treeview Control

RobDog888
Jun 20th, 2006, 11:28 AM
Just make sure you have the MS VB 6 runtime files installed on your system if you dont have VB 6. Also, you will need to distribute the ocx file with the workbook so other users can have the treeview control.

Static
Jun 20th, 2006, 11:32 AM
good thinking... ;)

RobDog888
Jun 20th, 2006, 11:39 AM
mscomctl.ocx is the actual filename you would need to distribute. :)

Fonty
Jun 20th, 2006, 03:58 PM
Im trying to add a node but I can. I'm using TreeView1.node.add()