Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating something like a file manager in Explorer with Excel Dara
I have 4 columns of data. The first is labeled "Category", next is "SubCateogory", and so on. I want to create something like what you see in Windows explorer that allows a user to expand a particular "Category" and see all the "SubCategory" values, and then click a "SubCategory" and see the "Products"...how do you do this???
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating something like a file manager in Explorer with Excel Dara
Sanjay,
You can use a TreeView control to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Sanjay1365" wrote in message ... I have 4 columns of data. The first is labeled "Category", next is "SubCateogory", and so on. I want to create something like what you see in Windows explorer that allows a user to expand a particular "Category" and see all the "SubCategory" values, and then click a "SubCategory" and see the "Products"...how do you do this??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating something like a file manager in Explorer with Excel Dara
Chip - I dont really know what TreeView is...typed it in help and looked up in glossary of my fat Excel book to no avail...I appreciate your help
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating something like a file manager in Explorer with Excel Dara
the treeview control is distributed with VB6 and the developer edition of
Office. -- Regards, Tom Ogilvy Sanjay1365 wrote in message ... Chip - I dont really know what TreeView is...typed it in help and looked up in glossary of my fat Excel book to no avail...I appreciate your help |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating something like a file manager in Explorer with Excel Dara
You could do this with group and outline under the data menu although you
would need to do the clicking in the outline area at the left of the sheet. See Excel help. It basically hides and unhides rows. -- Regards, Tmo Ogilvy Sanjay1365 wrote in message ... I have 4 columns of data. The first is labeled "Category", next is "SubCateogory", and so on. I want to create something like what you see in Windows explorer that allows a user to expand a particular "Category" and see all the "SubCategory" values, and then click a "SubCategory" and see the "Products"...how do you do this??? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating something like a file manager in Explorer with Excel Dara
Thanks Tom - I am plaing around with it right now (Group/Outline). It's not intuitive but I'll take a stab...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Jpeg links opening in Explorer instead of Picture Manager | Excel Worksheet Functions | |||
cannot open Excel file from Explorer | Setting up and Configuration of Excel | |||
Creating Scenarios and Scenario Manager | Excel Worksheet Functions | |||
Creating separate reports for each Project Manager | Excel Discussion (Misc queries) | |||
Double Click .xls file in Explorer opens Excel but no file | Setting up and Configuration of Excel |