asked on

How to add a TreeView Control Box in Excel 2010

Hi Experts,

am trying to add a TreeView from Control Box so I can apply table for
group and customers hierarchy.
I found this link :
http://www.excelguru.ca/content.php?194-Using-a-Treeview-Control

issue no 1 : am not good in VB to make use in my data.
issue no 2: I want the tree to Expand / Collapse . ( shows small plus sign ).
Issue no 3: I need it with multiable levels, not strickt to one level.

Thank you.
Group-and-Customer-levels.xlsx

Jacques Geday

Welll here it is on a user form. You need to have the file as macro enabled.
Just activate the button Load Tree on the form and see if this is what your looking for.
gowflow
Group-and-Customer-levels.xlsm

obad62

ASKER

HI gowflow,

Thank you for your response. Yes it workd as I userform , But I want to see the treeview in the cell. I will not load or read data from any source. I will build the groups and its customers one by one. see that attached as I tried to explained.

thank you.
Group-and-CustomSSSSer-levels.xlsm

Jacques Geday

I see what you want. Is it ok to do it in a form and treeview or you need it on the worksheet ? as this is available in 2010 and up but I hv 2007

gowflow

Jacques Geday

so ?

obad62

ASKER

Sorry for late rsponse. yes it is ok.

Jacques Geday

ok finally !!!!
Is this what your looking for ??? make any changes in the excel and Load Tree and see results.
gowflow
Group-and-CustomSSSSer-levels.xlsm

obad62

ASKER

Hi Gowflow, It works fine. the issue that if I close the tree form window box I cannot run it again from as a Macro, it required to make changes first, save it, colse the workseet, then I have to open it again to see the Tree box.

Thank you for your great efforts.

obad62

ASKER

Let me save your time, If you like to implement the tree macro.
Sys-Group-Heriarchy.xlsx

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Jacques Geday

Tks I am working on your file posted but will need more clarifications. If you want and post an other question pls put the link here so I can follow-it up
gowflow

obad62

ASKER

Hi gowflow,

I appreciate your effort. I posted a new Q :

https://www.experts-exchange.com/questions/28050674/Enhance-TreeForm-in-Excel.html

please ask if you have any question.

Ali

Jacques Geday

fine u will need to post a sample as I asked.
gowflow