Excel Treeview help

[eagerexcel]

hi Guys,

i have just found the treeview function within the user forms and would like to build one.

i have looked at a few examples of the data needed but cant figure out the codes to import the information.

to simplify it can someone please send me the makro or code for the following:

standard 3 sheets, i havde renamed the first to "Books"

Grouping would be the main list, where you will then be able to expand each group to see the list of athours and then down to the books.

in the user form the label field will then take the information in the synopsis cell

with the example below and the info above, is it possible to creat a code that will be able to "plug and play" with the ability to take on many more rows of information?

would really appreciate the help
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Group[/TD]
[TD]Author[/TD]
[TD]Book[/TD]
[TD]Synopsis[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD]Alex Archer[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]Destiny[/TD]
[TD][TABLE="width: 291"]
<tbody>[TR]
[TD]Archaeologist and explorer Annja Creed's fascination with the myths and mysteries of the past leads her to a crypt in the caves of France, where the terrifying legend of the Beast of Gevaudan hints at the unimaginable. What she discovers is shattering: an artifact that will seal her destiny; a brotherhood of monks willing to murder to protect their secret; and a powerful black-market occultist desperate to put his own claim to centuries-old blood money. Annja embarks on a high-tension race across Europe and history itself, intent on linking the unholy treachery of the ages with the staggering revelations of the present. But she must survive the shadow figures determined to silence her threat to their existence[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Footprints[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Forbidden City[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD]Adrian Tchaikovsky[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 112"]
<tbody>[TR]
[TD]Blood of The Mantis[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 112"]
<tbody>[TR]
[TD]Dragonfly Falling[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][TABLE="width: 93"]
<tbody>[TR]
[TD]Bret Easton[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 112"]
<tbody>[TR]
[TD]Glamorama[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 112"]
<tbody>[TR]
[TD]Imperial Bedrooms[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Norie]

You don't say where this data is or how it's organised.

 

[eagerexcel]

In an excel spreadsheet named "book listing"
the table above is in the first sheet of the workbook that i have renamed "Books"

the data is quite large which is why i would want a way to make the system select all the data within the sheet