Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Treeview additional components
Hi
I've just come across the MS Treeview 5 (SP2) components in the VBA toolbox from additional components., and have 2 questions. 1) Is there any disadvantage of using the additional components, in that are they installed by default on all PCs? or are they like add-ins and UDFs where something needs to be installed on all machines for it to work. 2) Where can i get more info on the Treeview control, i came across it via a Google search but can't find anything else on how to use it. What i want it to do is have a hiearachy like this FINANCE - Sales by regions - Sales by workers - Sales by product STAFF - Staff by region - Staff by title then when the user clicks finance it expands, then selecting sales by region takes the user to another worksheet or launches a macro. But i want the treeview to remain in the left side of the screen. All help is appreciated -- _______________________ Naz, London |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TreeView Help | Excel Programming | |||
Treeview | Excel Programming | |||
How to Treeview in VBA | Excel Programming | |||
TreeView | Excel Programming | |||
Treeview | Excel Programming |