Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TreeView Help Tony Excel Programming 0 September 21st 05 05:39 PM
Treeview Patrick Choi[_2_] Excel Programming 1 September 6th 04 08:29 AM
How to Treeview in VBA kvenku[_9_] Excel Programming 1 May 27th 04 01:03 PM
TreeView marijan glavac[_2_] Excel Programming 2 April 30th 04 07:28 AM
Treeview Max Scott Excel Programming 2 October 3rd 03 02:00 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"