Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chalange: Creating recursive tree from Excel List
Fellow Programming Experts, Can anyone provide a helping hand concerning the followin issue? I have a Excel representation of a recursive tree that looks lik that: Column A.............Column B *Parent................Child* Grand Father........Father Father..................Son1 Father..................Son2 Father..................Son3 Son1....................Grand Child1.1 Son1....................Grand Child1.2 Son2....................Grand Child2.1 Son2....................Grand Child2.2 Son2....................Grand Child2.3 Son3....................Grand Child3.1 … and so on. I need to load that data into a virtual tree in memory using a clas module that has three properties: Current Node Name First Child Next Sibling I know that the solution is a recursive function which instances th class module several times. I have implemented this frequently i various programming languages, however I am relatively new to VBA an can not figure out how to do it. Could anyone provide some sample lines of code I could start from describing: a) the class module (I have never used class modules before) and b) the function that loads the data into the tree? This would be fantastic!!! Any hint is very much appreciated. ur -- lenhardtur ----------------------------------------------------------------------- lenhardturs's Profile: http://www.excelforum.com/member.php...fo&userid=1584 View this thread: http://www.excelforum.com/showthread.php?threadid=27334 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you write a recursive formula in excel? | Excel Worksheet Functions | |||
Please help to list folders and subfolders tree in Excel or Word | Excel Discussion (Misc queries) | |||
Tree view in Excel | Excel Discussion (Misc queries) | |||
close workbook without closing excel and stop recursive function | Excel Discussion (Misc queries) | |||
Creating Tree Views in Excel | Excel Programming |