View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Naz Naz is offline
external usenet poster
 
Posts: 85
Default 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