N
Naz
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
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