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