ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Treeview additional components (https://www.excelbanter.com/excel-programming/399392-treeview-additional-components.html)

Naz

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


All times are GMT +1. The time now is 03:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com