Creating something like a file manager in Explorer with Excel Dara

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
Sanjay,

You can use a TreeView control to do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)


Sanjay1365 said:
I have 4 columns of data. The first is labeled "Category", next is
Click to expand...
"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???
 
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
 
the treeview control is distributed with VB6 and the developer edition of
Office.

--
Regards,
Tom Ogilvy

Sanjay1365 said:
Chip - I dont really know what TreeView is...typed it in help and looked
Click to expand...
up in glossary of my fat Excel book to no avail...I appreciate your help
 
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 said:
I have 4 columns of data. The first is labeled "Category", next is
Click to expand...
"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???
 
Thanks Tom - I am plaing around with it right now (Group/Outline). It's not intuitive but I'll take a stab...
 
Back
Top