Repeated Question

[John201]

Hi Guys,

I am new to excell and would welcome a solution to my problem. I posed this question before, but had no joy, so I am hoping today somone might be able to help.

My Question: how would i be able to render a dynamic skills tree in the following format (see attachment)


thanks

John

[davesexcel]

Check out this site

http://www.contextures.com/xlDataVal13.html

dependent drop down lists, when you select an item from a list the next list corresponds to that selection

There would be quite a bit of work involved to make it look like how you want, but it is possible

[John201]

thanks dave, I'll give it ago.

john

[Carim]

Hi,

Is your objective predominantly "cosmetic", or are you after some specific functionalities ?

Carim

[John201]

Hi Carim,

its not cosmetic. all i want is the functionality. Here is an online demo bro:

look at the folder example

http://javascript.cooldev.com/script...mos/superdemo/


I can do the above PHP(web programming), but just wondering whether it can be done in excel with macros or VB.

thanks

[Carim]

No need for VBA ...

but a long tedious work with shapes and hyperlinks ...

Carim

[John201]

is it too much asked to at least give me a kick start? Can you care?

Regards

[Carim]

Hi,

Attached a sample worksheet ...for a start ...

HTH
Carim

[John201]

Thank you for the example, i see you placed hyperlinks, but how do i the link them? for example: if i click on My Document, then My Music folder shuold display, then i want to click on My Music folder and song1 displays:-

-My Document
-My Music
song1




thanks again

[davesexcel]

Thanks you for the example, i see you placed hyperlinks, but how to i the link them? for example: if i click on My Document, then My Music folder display shuold display, then i want to click on My Music folder and song1 displays:-

-My Document
-My Music
song1




thanks again

You do know that the example is not excel don't you??

[John201]

no i did not know. i thought it was all in excel.

[Carim]

Right click select hyperlink

As far as expanding or collapsing, could Data Group and Outline fulfill your need ?

HTH
Carim

[John201]

i dont know how to do datagroup and outline?

[John201]

After more research i actually found a online tutorial of doing this using treeview control.

thanks

[Carim]

For the sake of sharing knowledge, which what this forum is all about,
could you kindly indicate the link you are referring to ...?

Carim

[davesexcel]

Here are some sites I found on tree view control

http://puremis.net/excel/code/080.shtml
http://www.geocities.com/dsteppan/ExcelTop.html
the above has a working example
http://www.andypope.info/vba/hlist.htm
as well as working examples

[Carim]

Hi Dave,

Thanks for your input...
It is always fun to keep on learning ...

Cheers
Carim

[John201]

sorry guys...should have put the link down, but dave has listed them and i used the same in particular: http://puremis.net/excel/code/080.shtml


thanks